abberyfarm
Well-known Member
- Joined
- Aug 14, 2011
- Messages
- 733
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))
If this returns noting (i.e. the cell in the table is empty), is there way to force it to lookup the value in the cell directly below and return it?
Many thanks
John
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))
If this returns noting (i.e. the cell in the table is empty), is there way to force it to lookup the value in the cell directly below and return it?
Many thanks
John