Well, it is doing the other vlookup but it is not finding the lookup value in
V222 (that is what #N/A means. The value being looked up was not found.

Assuming you are using this from Biff's reply

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

Check that the value you are entering in V222 (that is not 13) is in the
range 'Restype'!E$2:$f220. If it appears that it is there, check it closer.
There may be a space that you can't see that is causing it to be different
than the value in V222.
--
Kevin Vaughn


"suzyque" wrote:

> Thanks this works but now if the cell doesn't =13 I am getting #N/A - any
> suggestions - doesn't seem to be going to the other lookup
>
>
> "Kevin Vaughn" wrote:
>
> > I didn't try it, but it looks ok to me except that it would appear to do the
> > opposite of what you stated. if S222 = 13 then it will use
> > VLOOKUP(V222,'RES TYPE'!E$2:$F$220,6,FALSE)
> > The other thing is they are using different columns for the offsets (6 and
> > 2), but that may be what you intended. Other than that, how is it not
> > working? Ah, the 6 would be a problem because you are only looking in
> > columns e:f. Either expand your lookup range or change the 6 to 2.
> > --
> > Kevin Vaughn
> >
> >
> > "suzyque" wrote:
> >
> > > 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