Vlookup help needed ASAP!

1. Vlookup help needed ASAP!

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?

2. Re: Vlookup help needed ASAP!

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

3. Re: Vlookup help needed ASAP!

Hi Freedom041984,

Try this in column C on first sheet and drag down column:

``Please Login or Register  to view this content.``

4. Re: Vlookup help needed ASAP!

if after what bigroo gave you it still doesn't work, the problems could be the range he put in the formula, if so change =VLOOKUP(B2,Sheet2!\$B\$2:\$E\$6,4,0) to this =VLOOKUP(B2,Sheet2!\$B:\$E,4,0) or another acceptable range OR you could have what looks like numbers in one cell but are actually text and numbers in another cell or hidden spaces. To test for that simply find a value in one sheet that you believe matches in the other sheet and use something like this for example... =B2=B26 if the values look the same but that formula returns false then one of the two might be text while the other is a number or one of them might contain a hidden space. You can test those options out by using =isnumber(b2) or =istext(b2)

There are currently 1 users browsing this thread. (0 members and 1 guests)