Use..
=INDEX($A$1:$F$8,MATCH($D14,$F$1:$F$8,0),1)
Adjust red highlighted number for subsequent columns
Use..
=INDEX($A$1:$F$8,MATCH($D14,$F$1:$F$8,0),1)
Adjust red highlighted number for subsequent columns
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks