View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
petes_girl petes_girl is offline
external usenet poster
 
Posts: 2
Default 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