I'm trying to use the index/match formula to look up or return related
values. The key data is a 6 digit "VIN" number which sometimes begins
with 0. I enter the VIN on sheet1 A1 then other data that relates to
that VIN in B1,C1, etc. I then enter a new VIN on A2 and related data
on B2,C2 etc. down the line. On sheet2, I have an index match formula
to call the related data based on the matching VIN number. My formula
works for almost all vin numbers. But some return #N/A. I don't see
why or how to fix it. I've tried different formating.
Thanks for your help.
Don O