Forum Discussion
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 data into Row 184 and beyond, the formula now returns the values from row 1 of my data set when referencing 184 down(From the 10th column).
Index Match does the same thing.
Why would adding data into a table that is already inside the specified range at the end return basically my column headers?
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!
