with this function I get all values to show correctly except any over the
highest lookup value IF(ISERROR(VLOOKUP(...)),0,VLOOKUP(...)) my range of
part numbers to lookup are 1001-1100, so, if it is 0-1100 I get what I want
with my make, model, price. However If I enter a part number ranging from
1101-9999 I get the same info as if I entered 1100. How do I make it say "0"
instead?