Hi all,
I will use row 9 as the reference point here.
I have a number in Q9
I want to find that number in the range A9:F9 and then return the label which is in the adjacent cell (to the left).
i.e. if the value in Q9 is found in D9 the formula would return the value in C9.
It'd save me a huge amount of time if anyone can help me! Thanks in advance, Luke
One way:
=INDEX($A$9:$F$9,,MATCH(Q9,$A$9:$F$9,0)-1)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Maybe this...
=INDEX(A9:E9,MATCH(Q9,B9:F9,0))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks