How to match the values in excel

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

Procedure.xlsx (8.6 KB)

Please find the input excel

Hello @HeartCatcher

Aafter getting the value from column B, where you are mentioning this?
Inorder to filter the datatable based on the procedure Type, you can use use Filter Datatable activity and pass the value dynamcially.