Get instant live expert help on vlookup vs lookup
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Hi, Could you explain this into plain english please? =IF(AND($AY6552="SO",VLOOKUP($A6552,'Priority Lookup'!$A:$C,2,0)=3.06),"Bolt On",IF(AND($AY6552="SO",VLOOKUP($A6552,'Priority Lookup'!$A:$C,2,0)<>3.06),VLOOKUP((VLOOKUP($A6552,'Priority Lookup'!$A:$C,2,0)),'Product List'!$N:$U,8,0),VLOOKUP((VLOOKUP($A6552,'Priority Lookup'!$A:$C,3,0)),'Product List'!$O:$U,7,0)))
Solved by M. B. in 13 mins
Hi I'm trying to use fuzzy lookup. Not sure how it's working. I have two strings which are different ('Unemployment Benefits' vs 'Invalid pensioner'), yet getting a similarity index of 0.9474.
Solved by E. E. in 14 mins
can you explain why in the sales worksheet, vlookup function in column E range lookup is 0 while in column H the range lookup is true. what's the difference?
Solved by X. D. in 22 mins
I need help with a VLOOKUP formula to lookup multiple criteria from another worksheet
Solved by K. H. in 27 mins
very complex vlookup, if error lookup stuff please help! Already had some expert help, thanks
Solved by B. S. in 13 mins