can vlookup pull from 2 columns into 1 column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two spreadsheets, File A has 3 cols of numbers that I am trying to use
as a cross reference that has two columns of possibilites into File B. What I
would like to be able to do is have a vlookup created in File B that says to
go to File A col A and find a match, when you find the match look in col C.
If number is there then pull into File B, if empty go to col B to pull into
File B.
 
Try creating a helper column with something like B1&C1 in it. In the
vlookup, use

=vlookup(B1&C1, ... )

HTH,
Barb Reinhardt
 
What I am needing to do is lookup one column against a column in another file
and pull in the data out of two columns (if one is blank then it grabs the
2nd column of data)
 
Try this logic:

=IF(VLOOKUP(........first_column....)="",VLOOKUP(........other_column....),VLOOKUP(......first_column....))

Biff
 
This looks as if it might work for what I am needing. I will try this when I
get in the office in the morning. Thank you. Your help is greatly appreciated.
 
Back
Top