I am trying to do a simple Vlookup like I have done many times in the past in google sheets, but this one does not work for an unknown reason.

I want to get the date in Column B.

The formula in the VLOOKUP field is "=VLOOKUP(C3,B6:C8,1)" It says it did not find the value I am searching for.

CodePudding user response：

try:

=VLOOKUP(C3, {C6:C8, B6:B8}, 2, 0)

CodePudding user response：

Use the following

=VLOOKUP( N1,{N4:N6,M4:M6},2,0)

(Do adjust the formulae according to your ranges and locale)

Format the cell as date