What about this one (F2 contains the area value to be looked up):
=INDEX(B$2:B$7,IF(F2-0.001<0.01,1,MATCH(F2-0.001,A$2:A$7)+1))
Regards,
Stefi
€˛Rob_T€¯ ezt Ć*rta:
Unfortunately I can't change the spreadsheet the data is coming from,
and it's liable to change so I can't just copy the data, I need to link
to it.
So I need to work with the data in its existing format.
Any more suggestions out there?
Rob
--
Rob_T
------------------------------------------------------------------------
Rob_T's Profile: http://www.excelforum.com/member.php...fo&userid=4952
View this thread: http://www.excelforum.com/showthread...hreadid=540587