VLOOKUP not working

death4

New member
Joined
Oct 29, 2021
Messages
1
Reaction score
0
Points
0
Excel Version(s)
Excel 365
Hi,

I've been trying very hard to figure out why it won't work.

VLOOKUP from PASTE and find the data from the DB sheet and DISPLAY it in the first sheet.

Can someone help?
 

Attachments

  • test.xlsx
    10.6 KB · Views: 7
Hi, the values are not in the same format. One is formatted as number and the other is formatted as text. The better way is to format both values in the same format.
 
You can try to get around that, these may work:
=VLOOKUP(VALUE(PASTE!C1),DB!A1:C39,3,FALSE)
or
=VLOOKUP(PASTE!C1,TEXT(DB!A1:C39,"#"),3,FALSE)

But really, if these numbers are, for example, product id numbers which you wouldn't expect to arithmetic on, then they should all (on bothe sheets) be formatted as text, otherwise have them all numeric.
 
Back
Top