vlookup on multiple values
Insert a new column A.
In the new column A concatenate the data from what is now column B and
column C. Example of a row two formula:
=B2&" "&C2
Now you can use a vLookUp function on Column A with an offset of 4 to return
data from what is now column D.
Good Luck.
"samuel" wrote:
I have the following data in 3 columns
A B C
TOP BULB 1
TOP SCREW 5
TOP LIGHT 1
TOP LAMP 1
TOP PAPER 1
BOTTOM BULB 5
BOTTOM SCREW 4
BOTTOM LIGHT 2
BOTTOM LAMP 8
BOTTOM PAPER 7
I want to be able to first match against the value in column a then find the
match in column b once it finds both match then return the result of column
3.
|