Seeking help with a lookup problem

[abberyfarm]

Hi,

I am using the following formula to look up a number in a table:

=INDEX(A2:I26,MATCH(A1,A2:A26,0),MATCH(C1,A2:I2,0))

However, there are a number of blank cells in the table. If this formula returns noting (i.e. the cell in the table is empty), would anybody know if there is a way to get it to return the nearest available value below.

For example, I look up the value in the red cell, but it is empty so it returns the Green cell instead.

Excel Workbook
	Y	Z	AA	AB	AC
46	203	203		30	345
47	218	70		155	75
48	165	83		405
49		165	120	0	145
50	0	15	630	113	173
Expected Parking Time

Many thanks

John

 

[VoG]

Continuation of http://www.mrexcel.com/forum/showthread.php?646720-Seeking-help-with-a-lookup-problem

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).