Forum Discussion
Excel Formula Question
Hello, I am a very basic excel user, so please excuse any wrong terminology. I currently have a wage cost spread sheet built that pulls data from a few different excel spreadsheets. My issue is ...
Hello,
maybe you can use Index/Match instead of Vlookup? With Match you can look for the column that has the word "total" in a specific row. In this example, you can see the Vlookup formula, which is fixed to look in column E, and also the Index/Match formula, which can find the total, no matter which column it is in.
| =VLOOKUP("b",$A$2:$F$6,5,FALSE) |
| =INDEX($A$2:$F$6,MATCH("b",$A$2:$A$6,0),MATCH("total",$A$2:$F$2,0)) |