Forum Discussion
XLOOKUP or VLOOKUP help.
So I am trying to use the VLOOKUP or XLOOKUP function to find corresponding values in my data. Say I have some financials listed quarterly: 2015 Q1 - $2000 Q2 - $3000 Q3 - $4000 Q4 - $1000 ...
From your reply I can't seem to think why ti wouldn't work however I'm getting a #VALUE error. Any ideas?
Did you enter e.g. "Q1" and "2000" in seperate cells? It doesn't work if "Q1 - 2000" is in one cell as shown in the attached file. Maybe you want to attach an example copy of your file with dummy data.