can I use =if with vlookup statements

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

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

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
>
>
>

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

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

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

Slight change to this. The value being looked up was not in the range
E2:E220 (I said f220 previously, but it only checks the first column. In
this instance it returns what's in column F.)
--
Kevin Vaughn


"Kevin Vaughn" wrote:

> 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

Thanks Kevin - does it make a difference if the data in S222 or V222 is the
result of a =right command - could that be throwing it off? Thanks for your
time

"Kevin Vaughn" wrote:

> Slight change to this. The value being looked up was not in the range
> E2:E220 (I said f220 previously, but it only checks the first column. In
> this instance it returns what's in column F.)
> --
> Kevin Vaughn
>
>
> "Kevin Vaughn" wrote:
>
> > 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