troubleshooting Question

VLOOKUP in 1-2-3

Avatar of hazza96
hazza96 asked on
Lotus IBM
3 Comments1 Solution470 ViewsLast Modified:
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

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros