I need to figure out a way to search through multiple columns and rows for a value, then either return the row number it was located in, or the value of the first column in that row.
Something like this (hopefully formatting stays the same.
A B C D E F G H
———————————————–
1|IT | 1 | 8 | 6 | | | | |
———————————————–
2|HR | 2 | 9 | 4 | 11 | | | |
———————————————–
3|ACC | 21 | 98 | 42 | | | | |
———————————————–
4|MGM | 51 | 99 | 10 | 7 | | | |
———————————————–
5|TMP | 17| 22 | | | | | |
———————————————–
That’s the data sample, now off to the side, I want to have the values that populate the table (B1:H5) listed, and beside them, the heading for the row in whichthey are located(A1:A5). Each number in the table is unique, but may be moved from row to row, and each row isn’t sorted (can be sorted if necessary). The result would be something like:
10 MGM
4 HR
Now, if 4 was moved a row up, itwould change to:
10 MGM
4 IT
I’ve been racking my brains for a while now, any help will be much appreciated.
Thanks…