Here is my formula for cell I26: =IF(G26=" Armor Slot 2","",INDEX(G1:P97,MATCH(G25,N3:O97,0),16))
Here is an image of the sheet I'm working on: http://img301.imageshack.us/img301/1...lpsheetme1.jpg
When I activate the dropdown menu for the cell that says Armor Slot 2 and choose another "armor", I get a #N/A error in cell I26. Since using a string of IF statements to check which armor I'm searching for would result in the formula being too long, can anyone please help me find out what I'm doing wrong in this formula that's resulting in an error? I'm trying to choose an armor from a list of cells in column N and then display the value that corresponds to it, from column P, into cell I26.
(The list of armors extends down to row 97.)
Help would be MUCH appreciated!
Shadowboy
Bookmarks