CODEWITHSUNDEEP
excelexcel-formulamatchlookup
Mahmoud
Mahmoud

Reputation: 5

Lookup value with in range and return to first row cell

I have data in range B2:D6 , I need to search any value within this range and equation give corresponding cell in column A, if i search for H The result is 23 , also columnA may have duplicate, but search range have no duplicate .

enter image description here

Upvotes: 0

Views: 471

Answers (1)

Scott Craner
Scott Craner

Reputation: 152450

Use AGGREGATE:

=INDEX(A:A,AGGREGATE(15,7,ROW($B$2:$D$6)/($B$2:$D$6=H2),1))

Upvotes: 1

Related Questions