Hi All,
I need a help that is:
From the excel if the Procedure Type(Column name) is “Office visit and Office procedures only”
then I need to select value from “AppointmentType” column as “30BIOFEED”,
Like that If the Procedure Type is “Procedures only” then I need to select value from “AppointmentType” column as “COLONSC” and so on, i.e I need to select the value from B Column(“AppointmentType”) based on the value from column A(“Procedure Type”).
After that I need to put a condition that if the column A(“Procedure Type”) is “Procedures only” then I need to mention like “No member found” else I need to mention Like " member found".
Someone please do need ful.
Procedure Type | AppointmentType |
---|---|
Office visit and Office procedures only | 30BIOFEED |
Office visit and Office procedures only | 30CON |
Office visit and Office procedures only | ARM |
Office visit and Office procedures only | Capsule |
Procedures only | COLONSC |
Office visit and Office procedures only | CON |
Procedures only | DOUBLE |
Procedures only | EGD |
Procedures only | EGDBravo |
Procedures only | ERCP |
Procedures only | EUS-Upper |
Office visit and Office procedures only | F/U |
Office visit and Office procedures only | FlexSig |
Office visit and Office procedures only | Hem Tx |
Office visit and Office procedures only | HospF/U |
Office visit and Office procedures only | NP |
Office visit and Office procedures only | TelemedF/U |
Procedures only | TPA Colo |
Procedures only | TPA Double |
Procedures only | TPA EGD |
Office visit and Office procedures only | TPACON MCD |
Office visit and Office procedures only | URGENT |
Office visit and Office procedures only | US - 30 |
Office visit and Office procedures only | US - 45 |
Office visit and Office procedures only | US - 30 |
Office visit and Office procedures only | US - 45 |
@Palaniyappan
@ushu
@ppr
@Yoichi
@lakshman
@Gokul001
@Rahul_Unnikrishnan
@Nithinkrishna
@THIRU_NANI