I am trying to replace cells with information from another cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bissenjk@gmail.com - 09 Aug 2007 00:56 GMT

I have a report in excel that gives the diagnostic codes for a person.
I want the report to say the diagnosis insted of the code. I have a
list of what each code is in excel. Ex: Column I has the diagnosis by
number ( 711. or 739.99) column Q is numbered 710. - 739.9. Column R
gives the diagnosis for the code in the previous column. Is there any
way to have column I say its a certain diagnosis when it matches the
number in column Q which corresponds to column R. (basically I want
column I to be the verbage and not the codes).

Reply to this Message

Pete_UK - 09 Aug 2007 01:34 GMT

You will probably still need column I, but in another column you can
have a VLOOKUP formula which brings the text from your table which
corresponds to the code in I. Something like:

=IF(I2="","",VLOOKUP(I2,Q$2:R$500,2,0))

assuming you have a header row so that the data starts in row2, and
also assuming that you have 500 codes and descriptions - adjust to
suit, then copy down this helper column. You still enter the code in
column I, but then the description automatically appears in the column
with the formula in.

Hope this helps.

Pete

On Aug 9, 12:56 am, bisse...@gmail.com wrote:

> I have a report in excel that gives the diagnostic codes for a person.
> I want the report to say the diagnosis insted of the code. I have a
[quoted text clipped - 4 lines]
> number in column Q which corresponds to column R. (basically I want
> column I to be the verbage and not the codes).

Reply to this Message

Rate this thread: