Good Morning,

I am having huge problems trying to find the formula I need.

I have a large spreadsheet and another document which is the Bill.
What I need to do is to look up Column M on the Spreadsheet between
cells 10 to 500. and if there is a figure in any cells to return
column A.

if there is more than one figure between that range then I want the
second to appear in the cell below in the bill and so on.

Hope this makes sense, If anyone can help I will be so grateful.

Kind Regards, Vicky


--
VickyC
------------------------------------------------------------------------
VickyC's Profile: http://www.excelforum.com/member.php...o&userid=27391
View this thread: http://www.excelforum.com/showthread...hreadid=516823