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!”
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