can vlookup pull from 2 columns into 1 column?
 

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.

can vlookup pull from 2 columns into 1 column?
 

Try creating a helper column with something like B1&C1 in it. In the
vlookup, use

=vlookup(B1&C1, ... )

HTH,
Barb Reinhardt

"jennifer" wrote:

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.

can vlookup pull from 2 columns into 1 column?
 

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)

"Barb Reinhardt" wrote:

Try creating a helper column with something like B1&C1 in it. In the
vlookup, use

=vlookup(B1&C1, ... )

HTH,
Barb Reinhardt

"jennifer" wrote:

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.

can vlookup pull from 2 columns into 1 column?
 

Try this logic:

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

Biff

"jennifer" wrote in message
...
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)

"Barb Reinhardt" wrote:

Try creating a helper column with something like B1&C1 in it. In the
vlookup, use

=vlookup(B1&C1, ... )

HTH,
Barb Reinhardt

"jennifer" wrote:

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.

can vlookup pull from 2 columns into 1 column?
 

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.

"T. Valko" wrote:

Try this logic:

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

Biff

"jennifer" wrote in message
...
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)

"Barb Reinhardt" wrote:

Try creating a helper column with something like B1&C1 in it. In the
vlookup, use

=vlookup(B1&C1, ... )

HTH,
Barb Reinhardt

"jennifer" wrote:

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.