I am trying to replace cells with information from another cell

  • Thread starter Thread starter bissenjk
  • Start date Start date
B

bissenjk

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).
 
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
 
Back
Top