hi, just wondering if anybody has any ideas about solving this problem.

I have the following table


Min A% Max B% Max C% Max D% Name
0 1 1 1 James
99.5 0.1 0.3 0.1 Phillip
99.6 0.15 0.3 0.1 Mark
99.7 0.16 0.2 0.1 Adam
99.7 0.17 0.08 0.1 Peter

I have many records which look like the following,

A B C D Name
99.899 0.027 0.050 0.016 ??

Has any body got any ideas how I can use the first table to apply a
name to this record? I have many records to match so I was wondering if
there is any way of doing this automatically. I have tried using V
lookup, H lookup and If statements but so far i've had no luck.


--
qwerty_2006
------------------------------------------------------------------------
qwerty_2006's Profile: http://www.excelforum.com/member.php...o&userid=32303
View this thread: http://www.excelforum.com/showthread...hreadid=520576