Forum Discussion
Bringing Multiple Columns Over from VLOOKUP Table
Howdy folks, Looking for advice on a VLOOKUP task and how you might handle it. In this example, I have a template that has fixed values in the rows (Department names), and two columns (Charges a...
=IFERROR(VLOOKUP($A2,$F$17:$I$24,MATCH(TRUE,ISNUMBER(SEARCH(B$1,$G$16:$I$16)),0)+1,FALSE),"")
Does this formula return the intended result in the sample file? The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021. Once the size of the Pivot Table changes the ranges $F$17:$I$24 and $G$16:$I$16 of the formula must be adapted.