Using INDEX() to Locate Variable Data

[Shadowboy]

Here is my formula for cell I26: *=IF(G26=" Armor Slo
2","",INDEX(G197,MATCH(G25,N3:O97,0),16))*
Here is an image of the sheet I'm working on
http://img301.imageshack.us/img301/1826/helpsheetme1.jpg

When I activate the dropdown menu for the cell that says Armor Slot
and choose another "armor", I get a #N/A error in cell I26. Since usin
a string of IF statements to check which armor I'm searching for woul
result in the formula being too long, can anyone please help me fin
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 the
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!
Shadowbo

 

[Toppers]

Use VLOOKUP in I26 to retrieve value from column P

=VLOOKUP(G25,N3:O97,2,FALSE)

Looks up selection from G25 and finds corresponding entry in N:O

To allow for errors:

=If(ISERROR(VLOOKUP(G25,N3:O97,2,FALSE)),"",VLOOKUP(G25,N3:O97,2,FALSE))

in J26 to retrieve value from column O

=If(ISERROR(VLOOKUP(G25,N3:O97,3,FALSE)),"",VLOOKUP(G25,N3:O97,3,FALSE))

HTH

 

[Dave Peterson]

Typo alert.

Without reading the OP's message...

If the formula is retrieving from column P, shouldn't it be included in the
lookup range--and if that look up range starts in column O, then it would be the
3rd column:

=VLOOKUP(G25,N3:O97,2,FALSE)
becomes
=VLOOKUP(G25,N397,3,FALSE)

(in all the formulas)

 

[Toppers]

..... bad day at the office (home actually)! Thanks ...again!

 

[Shadowboy]

Thank you both for your fanstastic responses. My problem is solved and
I'm continuing along my way.