Dear all,

I've data in a table as follows:

Starting # Ending # Cabinet # Column # Row #

12345 45678 A 1 1
51000 65000 A 1 2
70000 78000 A 1 3

In the above table, if I type a number, say 60000 in a free cell, it returns
the result is in "Cabinet A, Column 1 and Row 2".

Please advise what formula I should put in the free cell so that i can get
my expected result? (I'm not sure VLOOK can look for a result in ranges)

Thanks in advance.