2 Cols To 2 Cols VLookup Comparison
 

Can anyone help? Need to know if there is a way to compare 2 cols. to 2
cols. VLookup. Info I have is for 1 col to 1 col. (single col. comparison)
Is there a way to compare multiple cols.?

2 Cols To 2 Cols VLookup Comparison
 

You can concatenate both columns to form a one to one comparison.
--
http://HelpExcel.com




"CuriousMe" wrote:

Can anyone help? Need to know if there is a way to compare 2 cols. to 2
cols. VLookup. Info I have is for 1 col to 1 col. (single col. comparison)
Is there a way to compare multiple cols.?

2 Cols To 2 Cols VLookup Comparison
 

Sure is:

Say you have names in col A, ages in col B, and address in col C. In
D1 you have the name of a person, and in E1 you have their age. You
want to know what their address is (ie col C value) from the list. You
can use:

=INDEX($C$1:$C$5,MATCH(1,($A$1:$A$5=D1)*($B$1:$B$5 =E1),0))

(obviously adjust ranges to suit - I have only used 5 cells here).
This is an array formula so must be array-entered (Ctrl+Shift+Enter).

Hope this helps!

Richard



CuriousMe wrote:
Can anyone help? Need to know if there is a way to compare 2 cols. to 2
cols. VLookup. Info I have is for 1 col to 1 col. (single col. comparison)
Is there a way to compare multiple cols.?

2 Cols To 2 Cols VLookup Comparison
 

Thank you for your response...Merry Christmas!!

"galimi" wrote:

You can concatenate both columns to form a one to one comparison.
--
http://HelpExcel.com




"CuriousMe" wrote:

Can anyone help? Need to know if there is a way to compare 2 cols. to 2
cols. VLookup. Info I have is for 1 col to 1 col. (single col. comparison)
Is there a way to compare multiple cols.?

2 Cols To 2 Cols VLookup Comparison
 

Thanks so much...Merry Christmas!

"RichardSchollar" wrote:

Sure is:

Say you have names in col A, ages in col B, and address in col C. In
D1 you have the name of a person, and in E1 you have their age. You
want to know what their address is (ie col C value) from the list. You
can use:

=INDEX($C$1:$C$5,MATCH(1,($A$1:$A$5=D1)*($B$1:$B$5 =E1),0))

(obviously adjust ranges to suit - I have only used 5 cells here).
This is an array formula so must be array-entered (Ctrl+Shift+Enter).

Hope this helps!

Richard



CuriousMe wrote:
Can anyone help? Need to know if there is a way to compare 2 cols. to 2
cols. VLookup. Info I have is for 1 col to 1 col. (single col. comparison)
Is there a way to compare multiple cols.?