I tried an index match, and the hlookup, but am just not quite getting the results returned I am after. I have data that spans all the way over to AF column, and I want to pull over the value requested to the master workbook.
Attached is a sample workbook, what vba, and/or worksheet function could achieve this?
Further Explenation, On Sheet1 I want to look up the numeric value from the row that matches ID 42123 and matches the value ABCDEFF and return that to C2 from sheet2, then match on the ID 42123 and match on the value RSTLMNO and return the value to F2 from sheet2
So expected returned results would be:
42123 ABCDEFF 18 RSTLMNO 1
49182 ZZYY 4 BBCCC 3
What formula would achieve that result?
Bookmarks