Get instant live expert help on I need help with excel vlookup text

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

i am performing a vlookup however it is not working even though i can find the text
Solved by B. B. in 28 mins
write a formula, i need vlookup to return a text and now a number
Solved by K. C. in 25 mins
iferror with a existing vlookup function that results in a Invalid Staff ID text
Solved by S. C. in 15 mins
I need help to fix a logic check formula to compare two values, but pull one as text *1 to take formatting into account. I'm attempting '=IF(INDEX(TEXT(A16,"0"))*1)=(INDEX(C16)),"CORRECT","FAIL" but a VLOOKUP might work as effectively Relates to a significant excel bug - see sheet
Solved by V. U. in 28 mins
Add a formula to cell G4 that creates a Report ID from the date and the ID number on the ListData worksheet of the person who made the report. The IF function will include a TEXT function and a nested IF function with a VLOOKUP function. The logical test will verify if cell G2 is greater than 0. The value if true will include the TEXT and VLOOKUP functions: TEXT(G2,"YYYYMMDD"),"")&" "&IF(G1>0,VLOOKUP(G1,ListData!B15:C19,2) The value if false will return blank.
Solved by A. A. in 27 mins