Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

VLOOKUP Woes

Brass Contributor

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? 

5 Replies

@Danger_SF - You need to change the table reference since it's not a table. Just replace "[@[Employee ID]]" with the cell reference A2.

 

SanthoshKunder_1-1695788062734.png

@SanthoshKunder 

 

Sorry. In those example workbooks, I neglected to format the cells as tables. In the documents I'm working with, they are all tables.

 

If you format them as tables, can you tell me why the formulas don't work?

@Danger_SF 

=VLOOKUP([Employee ID],[HR.xlsx]Tab3!$A$2:$B$3,2,FALSE)

This works on my computer if all three files are open.

vlookup.png

 

best response confirmed by Danger_SF (Brass Contributor)
Solution
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.
Disregard. Sorry for the bother. I figured it out.
1 best response

Accepted Solutions
best response confirmed by Danger_SF (Brass Contributor)
Solution
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.

View solution in original post