Problems with the VLOOKUP function

27 views

Skip to first unread message

Chayo

unread,

May 27, 2022, 7:54:41 PM5/27/22

to Google Sheets Community

I am using the VLOOKUP function but it is giving me the wrong data.
The function I wrote is =VLOOKUP(A2,B2:C10,2,2) and instead of returning the value 1 it returns 2.

WhatsApp Image 2022-05-27 at 10.22.04 AM.jpeg

Alexander Ivanov

unread,

May 30, 2022, 1:53:37 AM5/30/22

to Google Sheets Community

Hi!

Did you try use zero instead?

=VLOOKUP(A2,B2:C10,2,0)

Reply all

Reply to author

Forward

0 new messages