Vlookup and Match problem

[DocAElstein]

Hello bobkap12 , Welcome to ExcelFox

When the variable in cell C2 of the "Working" ….. If you change C2 …..

????? –
I think maybe you mean C6 ?

---

I made a start and you can see how I approach the problem, see my notes here: https://excelfox.com/forum/showthrea...ll=1#post16713
https://excelfox.com/forum/showthrea...ll=1#post16721

I notice a couple of strange things on first investigations
_1) some character combinations are not working as the look up value, such as , for example "dmg1"
_2) In addition, the actual value given when the VLookUp is working appear to be incorrect sometimes.

I am puzzled.

I have no more time to look at this today.
Maybe someone else can shed some light on these puzzling results.
If you and no one else can solve the problem in the next few days, then I will take another look when I have more time.

Sorry I don’t have a solution to the problem yet.

My next step would be to step by step, reduce and simplify the data whilst maintaining the strange problems. This would usually make it much easier to isolate the problem




Alan