CODEWITHSUNDEEP
google-sheetsvlookup
Frank White
Frank White

Reputation: 321

Google sheets simple Vlookup not working with code included

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. enter image description here

Upvotes: 0

Views: 211

Answers (2)

player0
player0

Reputation: 1

try:

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

Upvotes: 1

marikamitsos
marikamitsos

Reputation: 10573

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

enter image description here

Upvotes: 0

Related Questions