Hi, i am doing a vlookup table matching different drinks in different machine, the formula working very well with the first 10 machine. However, with the new one, machine 2, the result of the formula shows 0 even there is a existing match.
Hi, i am doing a vlookup table matching different drinks in different machine, the formula working very well with the first 10 machine. However, with the new one, machine 2, the result of the formula shows 0 even there is a existing match.
Last edited by garycpl1031; 12-24-2019 at 03:56 AM.
Welcome to the forum.
D1002 on the slot sheet is blank - that's why the lookup is returning zero. It has nothing to do with the machine code in the green cell - this is not referenced on the formula.
Where do you believe there is a match for that cell?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Your method of combining slot number and machine code is flawed
slot number 1 and machine code 32
and
slot number 13 and machine code 2
give identical results (132)
this will be repeated in other cases most likely throughout the sheet
you need to change your concatenation
maybe something like slot & "0000" & machine code.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
Because =VLOOKUP(B13;'slot layout Data'!$C:$D;2;FALSE) ( for example) finds 132 in C302 and returns 0 as it should. You have duplicate lookup values in col C
Thank you very much the problem has solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks