Hello,
I am trying to figure out a good way to have excel lookup a value based on the nth column of an array and returning the first with the nth column being variable. Example:
A B C D 1 Output #1 #2 #3 2 1 10 20 30 3 2 11 21 31 4 3 12 22 32 5 4 13 23 33
Input1 = #3 (but could be #1, #2, or #3 and will change based off of inputs)
Input2 = 32
Desired output = 3
Input 1 will need to match the columns B, C, or D, which will return the correct column to look for Input2 in. Then within that column, find the row that contains Input2 with an output coming from A.
I attempted to use index/match function to do this but couldn't figure it out. I know that I could break up the data and do an easy VLookup on B then A, C then A, and D then A but I feel like there is a way to do it how I want. Also, I have roughly 213 columns worth of data that would need to be done like this.
Any help would be appreciated. Also, if this isn't possible, please let me know!
Bookmarks