Match gives you the row. You then use that with Index to return the value
you want

=Index(column with return values,Match(set up to do your match),1)

Entered with Ctrl+Shift+enter since this is an array formula.

--
regards,
Tom Ogilvy

"klysell" wrote:

Hi,

I have a vlookup fuction - e.g. (VLOOKUP($C$3,_Map1,8,FALSE) - that needs to
lookup the value (in the 8th position) in $C$3 (current sheet) that is equal
to the concatenated value of the first and second column values in my range,
"_Map1", which is contained on my "Summary" sheet.

For example, my value for $C$3 is "Lysell, Kent(17)". I need to lookup up
the particular row in my range where column c value is "Lysell, Kent" and the
adjacent column d value is "17" ("17" in column d doesn't have "()" around it.

I've seen other solutions on this DG, but these are using the "match"
function. Is this solution adaptable to my "vlookup" function? Or should I
change all my formulas to the "match" fn?

Thanks in advance!


--
Kent Lysell
Financial Consultant
Ottawa, Ontario
W: 613.943.9098