Hello all,
I have a small table on Sheet9. In column B & C are a series of numbers.
The match number for column B will appear in columns E or G in Sheet 2 and the matching number for column C will appear in Column I on Sheet 2. The range is dynamic in sheet 2, based on data that is imported.
I want to return the value from Column B in Sheet2 in H3 on Sheet9 for the 1st instance that the values in Columns B and C from Sheet 9 appear in Columns E/G and I in Sheet 2...
Anyone assist?
Bookmarks