Get instant live expert help on vlookup returning wrong value
“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
my nested dcount function is returning the wrong value it is returning 0 instead of no records found as specified in my if function
Solved by X. H. in 19 mins
the vlookup function is not working properly and is returning wrong values when i am searching from an another file
Solved by A. Y. in 22 mins
Vlookup isn't returning value unless i double click in the original data cell and press enter on every line
Solved by Z. Y. in 24 mins
Hi there, could you please tell me what is wrong with this function: =IFERROR(VLOOKUP(LEFT(A4,4)&"_"&B4&"_"LEN(A4:B4),CustomerTable,2,FALSE),0). It is returning an error value and I am pretty sure it is to do with the LEN section but can't work it out
Solved by C. J. in 21 mins
hi I need a formula that selects by criteria A or B and then does a Vlookup for based on a specific value returning value A or Value B
Solved by G. U. in 13 mins