Hi!

Try this:

=IF(S222=13,VLOOKUP(S222,'RES TYPE'!A$2:$B$220,2,FALSE),VLOOKUP(V222,'RES
TYPE'!E$2:$F$220,2,FALSE))

Biff

"suzyque" wrote in message
...
I would like to use an if statement to fill in data in one column - I have
1
lookup table with 6 columns and a spreadsheet with multiple columns -
basically I want to ask if a cell=13 go to my look up table"res type"
A$2:$B$220 if not go to the same lookup table but go to E$2:$F$220
this is what I wrote but it is not working:
=IF(S222=13,VLOOKUP(V222,'RES TYPE'!E$2:$F$220,6,FALSE),VLOOKUP(S222,'RES
TYPE'!A$2:$B$220,2,FALSE))
I could really use some help - thanks