Please can someone help me here.

I have 3 columns.

1st column has Diagnosis Codes = 123.8 etc, but in no particular
order.

2nd column has the complete diagnosis codes list, starting at one going
on to 12490 fields.

3rd column relates to the text of the diagnosis code ie, if column 2 =
123.9 then column 3 would say Pregnancy Tests.

What I need is to compare column 1 with column 2 so I can get the
correct text from column 3. This will then tell me what the diagnosis
text is for column 1.

I know this is long winded but I need to know so I can keep my job. I
have tried everything in my small head to get around this.


--
Alisdair
------------------------------------------------------------------------
Alisdair's Profile: http://www.excelforum.com/member.php...o&userid=33354
View this thread: http://www.excelforum.com/showthread...hreadid=531863