Forum Discussion
Solved
VLOOKUP Woes
The attached FAC worksheet is supposed to pull data from the HR and Finance sheets. However, the formulas on the FAC sheet aren't working. I can't figure out why. Can anyone help?
- Thank you. But could you also get the Finance tab data to lookup?
The issue in finding is that one or the other of the formulas will work, but not both.
=VLOOKUP([Employee ID],[HR.xlsx]Tab3!$A$2:$B$3,2,FALSE)This works on my computer if all three files are open.