I struggle big time with Vlookup. I just started in a position using Excel and I swear it has only worked 1/5,000 times :-( so frustrated right now and hating Excel. Here's the situation:
First sheet:
List of ee numbers (column B2)
Goal: Match the ee numbers up with their correct dept mgr
Second Sheet:
Table array is Sheet2!B:E (aka highlighting the ee numbers up to the dept mgr)
Column index: 4
Range lookup: FALSE
End result: NA straight down the line, wahhh :-(
I made sure everything was formatted as general, even played around with concerting the ee #'s to #. Nothing works. I really, really appreciate any guidance and support you can provide?
Bookmarks