i have a problem that i don't think index match can solve.
I have 2 sets of data, i want to use one set to look up the other set and return a value in the same row but another column. the problem is that the lookup range and the respective return results are not each in one column. For example:
<tbody>
</tbody>
What formula, or combination of formulas could I use so that 166058 returns Name4 AND 452000 returns Name6? Things to note: in every row of the data we are searching in, only 3 cells have data in them and there is a consistent spacing of blank cells in between. The lookup value will be the second piece of data in that row, and the return value will be the 3rd.
I have 2 sets of data, i want to use one set to look up the other set and return a value in the same row but another column. the problem is that the lookup range and the respective return results are not each in one column. For example:
lookup value | range | range | return | return |
166058 | 880507 | Name1 | ||
167885 | 558833 | Name2 | ||
452000 | 554411 | Name3 | ||
880507 | 166058 | Name4 | ||
552266 | Name5 | |||
452000 | Name6 | |||
167885 | Name7 |
<tbody>
</tbody>
What formula, or combination of formulas could I use so that 166058 returns Name4 AND 452000 returns Name6? Things to note: in every row of the data we are searching in, only 3 cells have data in them and there is a consistent spacing of blank cells in between. The lookup value will be the second piece of data in that row, and the return value will be the 3rd.