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.?