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