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

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