I have been tasked with seeing if I can pull column header info into a report. The report uses a series of lookups to pull information from two different sources. The lookup value is in column B, table array is B:O. My challenges is that I need to look at columns j-o by row and find the column with the last value and return the column header value, is this possible? Sample-Level.xlsx
Your ranges didn't start and end at same row number.
=IFERROR(INDEX('[Test-Forecast.xls]Forecast Summary'!$J$1:$O$1,MATCH(10^10,INDEX('[Test-Forecast.xls]Forecast Summary'!$J$3:$O$175,MATCH(B3,'[Test-Forecast.xls]Forecast
While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful. I tested several solutions and share the results in this article as well as t…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…