Jun 08 2022 02:42 PM
I am having trouble with VLOOKUP. I have created the following =VLOOKUP(C6,L8:II51,3) whereby the value in C6 is the biproduct of A6 and B6 through =CONCATENATE(A6,B6). The range and the column number (look above to cell N3 for the column number) for the requested data to be pulled from relates to the cell N8 and as you can see I get a 0 (zero) instead of 02/01/22. The cell formatting is "General" but I have tried other cell formats such as currency, accounting, number, date etc. but no change. I have also copy/pasted this sheet to another newly created sheet (actually created a new sheet then after creation pasted the entire original sheet's contents to this new sheet and same result. I have included (2) screen captures to illustrate this condition and am hoping someone can shed some light on this crazy result.
Thanks in advance!
Jun 08 2022 02:52 PM
SolutionChange the formula to =VLOOKUP(C6,L8:II51,3,FALSE)
Jun 08 2022 03:14 PM
Jun 08 2022 02:52 PM
Solution