VLOOKUP + MATCH on column headers
Hi, I have a reference sheet set up with a list of milestone names/build versions/dates and am trying to use VLOOKUP + MATCH to auto-pull those in a 2nd sheet.
For example - Sheet1 uses =VLOOKUP("ZBR", Milestones1:[2.0]7, MATCH("1.4", [Column Headers], false))
Where "Milestones1:[2.0]7" is a table of milestones/build versions/dates in the referenced sheet. And [Column Headers] would be the column headers in that same sheet, if I could actually find a way to reference them via formula.
I've also tried pasting the header names in the cells underneath, but it doesn't work right seeing that the column values need to be formatted as dates.
The following screenshot is from my reference sheet.
Help Article Resources
Check out the Formula Handbook template!