Your right I should have explained what it does. I have put a
simplified version below.

It is comparing the value of a single cell to multiple values, it is
based upon a Lookup Worksheet that has a 2 Column range defined as
FNums

1 1
2 2
3 3
4 4
5 5
6 6
21 7
31 8
32 9
34 10
41 10
42 10
43 10
44 10
51 11
61 12
71 13

=IF(ISNUMBER(1/(LOOKUP(CJ27,FNums)))CHOOSE(LOOKUP(CJ27, FNum),"Text
based upon results of lookup", "Text based upon reslults of lookup",
etc......), "CJ27")

Martin

davesexcel wrote:
> I am not quite sure what this is ,
> Maybe you could check out this site VLOOKUP and see if it could help
> you,
>
> http://www.contextures.com/xlFunctions02.html
>
>
> --
> davesexcel
>
>
> ------------------------------------------------------------------------
> davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=574439