Forum Discussion

Copper Contributor

Jan 27, 2023

VLOOKUP returns wrong data

I have a simple VLOOKUP as follows in cell C23 =VLOOKUP(B23,Serialized!$A$1:$O$300,10) Where my data set is on tab "Serialized" My data set in "Serialized" only goes to ROW 183. Now, as I add dat...

excel

Formulas and Functions

HansVogelaar

MVP

Jan 27, 2023

gnagystrap

Try

=VLOOKUP(B23,Serialized!$A$1:$O$300,10,FALSE)

gnagystrap
Copper Contributor
Jan 27, 2023
HansVogelaar
Thank you that worked. Since my values in B23 are from a data validated drop down box referencing Serialized A1:A300 I didnt think false would come into play.

Thanks for the help!