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

"Biff" wrote:

> 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" <suzyque@discussions.microsoft.com> wrote in message
> news:8F96536F-4482-4A04-8933-181AD558C91E@microsoft.com...
> >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
>
>
>