I was just trying out the old LOOKUP function of excel, but every time it is returning me few wrong values. What's wrong with this lookup function?
Yeah I know there are better formulas like vlookup, index/match, the latest xlookup to do the same thing. But I just wanna wanna know what I'm doing wrong over here? or the lookup function itself has any bug? Please correct me
I'm attaching the excel file below.
Bookmarks