CODEWITHSUNDEEP
excelexcel-formulaexcel-2010
Tushar Varshney
Tushar Varshney

Reputation: 55

Check if Cell value exists in Row, and return a value in the same Column but different Row

For instance i need to check The first instance where the value lies in range "B3:AY3", and return it's corresponding value from Row 2

Upvotes: 0

Views: 12617

Answers (1)

barry houdini
barry houdini

Reputation: 46341

You can use INDEX and MATCH functions to do this, e.g. if lookup value is in A1 this formula will find the first A1 value in B3:AY3 and return the corresponding value from row 2

=INDEX(B$2:AY$2,MATCH(A1,B3:AY3,0))

Upvotes: 2

Related Questions