Hi,

Am Mon, 2 Apr 2012 02:52:14 +0000 schrieb rethish:

In my Column B, I have 309.5,328.8,-410.5,-80.3,-1.4

In Column A, I have 1228.3,943.7,44.4,301.1,688.7.

The formula needs to search for 410.5 in Column B and subsequently give
44.4 as result.

try:
=INDEX(A1:A5,MATCH(D1,ABS(B1:B5),1))
This formula is an array formula to enter with CTRL+SHIFT+ENTER


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2