Vlookup refuses to cooperate for 48+ hours
Good morning
I am experiencing terrible problem with VLOOKUP
I want that function to give me Lead time of supplier which supplies me with items. So I have item numbers, Suppliers IDs and also Lead Time
That function refuses to work in the worksheet and I tried to normalize numbers, different file...I tried also index match and it also didn't work.
I have no clue where could be problem.
Anybody who can tell me why is this problem occuring? Thank you in advance.
Have a nice day
Last edited by kamil666; 05-18-2021 at 12:02 AM. Reason: solved
F2 might be imported from other source, it displays as number, but it is in left margin, then it is stored as text.
You have 2 options:
1) Keep original format:
=VLOOKUP(F2+0,Supplier,2,FALSE)
2) Convert column F to become value by "add zero" to the text to activate them:
Copy any available cell (blank cell)
Choose column F
Paste Special/Operation: Add
Quang PT
It is working. I cannot be enough thankful. I spend two days and nights by moving the cells and trying to make it work. It is for university so If i couldn't make it work, I couldn't do analysis of the data and that would mean, if I wouldn't pass 2 more subjects they would fire me
I go now look on how it could get this wrong so I will never send to somebody datasheet as this one. THANK YOU !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks