Tridiro
Board Regular
- Joined
- Apr 26, 2007
- Messages
- 97
Hello Everyone,
I need to get excel to deliver a sum from 75 different arrays that are spreed out over 15 separate worksheets (in the same workbook ).
My problem is this, Each array will have a slightly different set of values in the far left column; which returns the error "A value is not available to the formula or function".
In Plain English, If BOB, TOM and SUE are in the left column in the first array, and BOB, BILL and Sue are in the first column of the second array; then the error occurs when I search for TOM because he is not in the second array.
This is the formula i am using.
{=VLOOKUP($A$12,table1,3,0)+VLOOKUP(A12,talbe8,3,0)+VLOOKUP(A12,table3,3,0)}
Please help! Im so Stuck, I need a workaround!
I need to get excel to deliver a sum from 75 different arrays that are spreed out over 15 separate worksheets (in the same workbook ).
My problem is this, Each array will have a slightly different set of values in the far left column; which returns the error "A value is not available to the formula or function".
In Plain English, If BOB, TOM and SUE are in the left column in the first array, and BOB, BILL and Sue are in the first column of the second array; then the error occurs when I search for TOM because he is not in the second array.
This is the formula i am using.
{=VLOOKUP($A$12,table1,3,0)+VLOOKUP(A12,talbe8,3,0)+VLOOKUP(A12,table3,3,0)}
Please help! Im so Stuck, I need a workaround!