I am trying to use vlookup in the following scenario and need help with the
correct formula.

Sheet 0
a b
ABC =vlookup(A1, Sheet1!1:65536, 2, false)


I am trying to return the "Peanuts" from sheet1 but it is not allowing me to
as the partial vaule from Sheet0 (ABC) does not match the value from Sheet1
(ABC123).
Sheet1
a b
ABC123 Peanuts


Any help is greatly appreciated!