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

Hi Freedom041984,

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

Please Login or Register  to view this content.

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)