CODEWITHSUNDEEP
excelexcel-formula
imbalize
imbalize

Reputation: 41

Lookup Excel Column, Row

Having a bit of a struggle.

I really have no clue how to do this type of lookup.

I want to lookup the date in column, find the value 1 within that column and return the name on the same row to the left.

Is it possible to do this or do I need to redesign the table?

enter image description here

Upvotes: 0

Views: 84

Answers (1)

basic
basic

Reputation: 11968

INDEX/MATCH can help you:

=INDEX(B:B,MATCH(A12,INDEX(A1:G8,0,MATCH(A11,1:1,0)),0))

Adjust ranges to your needs.

enter image description here

Upvotes: 1

Related Questions