How do I tell a match function to look in a certain row for data?
For example
1221 23 89
2213 81 22
9901 77 91
I want to be able to tell match to search the row with 2213 in it so I can determine which position or column 22 is in. I do have the ability to tell it what row it is in, can't figure out how to convert that into array data.....for example since 2213 is in row 2, can't figure how to make the array in match to be A2:F2. (fixed or defined arrays are out, move the data out, update and return frequently)
Thank you for the help!
For example
1221 23 89
2213 81 22
9901 77 91
I want to be able to tell match to search the row with 2213 in it so I can determine which position or column 22 is in. I do have the ability to tell it what row it is in, can't figure out how to convert that into array data.....for example since 2213 is in row 2, can't figure how to make the array in match to be A2:F2. (fixed or defined arrays are out, move the data out, update and return frequently)
Thank you for the help!