I have named a range A1:B10 called 'prices'.
I then use the formula @VLOOKUP(A15,$prices,(2)-1) in cell B15.
If the entire range is filled out then I get the correct result. If however there is nothing in A10 and I enter a number in A15 that is larger than A9 it returns a 0.
If I do the same thing in Excel then it returns the value of A9.
I wanted to create a Dynamic range, (Excel can) so that the range only includes cells that information in them, but can't find any info about it. Sometimes the info in the range only has 4 lines other times it fills all 10.
Does anyone know to:
1. Solve the VLOOKUP problem, or
2. Create a dynamic range in 123