If your data is in A1:D3 and lookup value [5] in E2 use this formula in F2
=LOOKUP(E2,A2:D2,A1:D1)
As you can see row 3 isn't used, it's not necessary if your ranges are contiguous
If your data is in A1:D3 and lookup value [5] in E2 use this formula in F2
=LOOKUP(E2,A2:D2,A1:D1)
As you can see row 3 isn't used, it's not necessary if your ranges are contiguous
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks