bill351
Board Regular
- Joined
- Jan 19, 2009
- Messages
- 83
Hey Guys and Girls
I am puzzled, I have a spreadsheet with formulas for different section on the sheet 2 work perfectly the 3rd not so good all formulas are similar its just the Index data and match data accessing different columns.
My problem one is =INDEX(Data!F2:F13,MATCH(F3,Data!G2:G13,0),1) where the formula is in E3
Data!F2:F13 is the names
F3 is a drop down list with the names
Data!G2:G13 are the cost centers
and the result is in E3 #N/A ?? I have checked the names are the same the cell formatting is Ok, I have swapped columns around but nothing. I know its something simple Because the other 2 formulas sitting in columns A and C work just fine so I am hoping you can point out my error
Cheers from Oz
I am puzzled, I have a spreadsheet with formulas for different section on the sheet 2 work perfectly the 3rd not so good all formulas are similar its just the Index data and match data accessing different columns.
My problem one is =INDEX(Data!F2:F13,MATCH(F3,Data!G2:G13,0),1) where the formula is in E3
Data!F2:F13 is the names
F3 is a drop down list with the names
Data!G2:G13 are the cost centers
and the result is in E3 #N/A ?? I have checked the names are the same the cell formatting is Ok, I have swapped columns around but nothing. I know its something simple Because the other 2 formulas sitting in columns A and C work just fine so I am hoping you can point out my error
Cheers from Oz