Help with If and Vlookup
 

Hi all

I think this could be a nice easy one, I have a spreadsheet across columns A
to G, with a vlookup working nicely, relating to a data worksheet with
Columns A to C:

=vlookup(A2,Data!A:C,2,false) this gives results of either a
or b

What I need it to do is if the result is a then I want column c to go into
the cell but if it is b then leave blank.

Many thanks in advance

Help with If and Vlookup
 

One way:

=IF(VLOOKUP(A2,Data!A:B,2,FALSE)="a",VLOOKUP(A2,Da ta!A:C,3),"")

Regards,
Paul

"petes_girl" <u28569@uwe wrote in message news:68a7ed8817473@uwe...
Hi all

I think this could be a nice easy one, I have a spreadsheet across columns
A
to G, with a vlookup working nicely, relating to a data worksheet with
Columns A to C:

=vlookup(A2,Data!A:C,2,false) this gives results of either
a
or b

What I need it to do is if the result is a then I want column c to go into
the cell but if it is b then leave blank.

Many thanks in advance

Help with If and Vlookup
 

Thats great Paul, I knew if would be something simple.

It works just fine.

Petes_girl

PCLIVE wrote:
One way:

=IF(VLOOKUP(A2,Data!A:B,2,FALSE)="a",VLOOKUP(A2,D ata!A:C,3),"")

Regards,
Paul

Hi all

[quoted text clipped - 11 lines]

Many thanks in advance