Vlookup data?

[fairymemay (noona)]

I want vlookup data as below (read by row data file input).

• column S_Catagory (file input) with column Category (file master Sheet1)
• column S_Sub Catagory (file input) with column Sub Catagory(file master Sheet1)
  
  

If match message box value in column feedback_Recommendation
else not match check next sheet
i want tot check as below.

• column S_Catagory (file input) with column Category (file master Sheet2)
• column S_Sub Catagory (file input) with column Sub Catagory(file master Sheet2)
• column Issue (file input) with column Issue(file master Sheet2)

If match get message box valur from column feedback_Recommendation
else message box = not found.

Expect output round1 row1 message box = test4
round2 row2 message box = Not Found

Please guide me about it.

Thank you.

input.xlsx (8.1 KB)
Master.xlsx (11.8 KB)

[Jayesh_678 (Jayesh)]

Hi @fairymemay

Output:-

Xaml file:-
lookup data forum.zip (19.1 KB)

If this works for you, please mark it as a solution, so others can refer the same…

Thanks

[fairymemay (noona)]

@Jayesh_678 I have a question if I want read data (for each row) by use table input.
Can you guide me for edit code?

[Jayesh_678 (Jayesh)]

Hi @fairymemay ,

Can you please elaborate more on the problem statement.

I suggest, if the post is mark as a solution, then please create a new post.

Thanks.

[fairymemay (noona)]

I want to start step with for each row by input_dt

Because I want to read data by row input_dt for next step.

I create new post already.

Vlookup data by input?

@gRao I want vlookup data as below (read by row data file input). column S_Catagory (file input) with column Category (file master Sheet1) column S_Sub Catagory (file input) with column Sub Catagory(file master Sheet1) [image] If match message box value in column feedback_Recommendation else not match check next sheet i want tot check as below. column S_Catagory (file input) with column Category (file master Sheet2) column S_Sub Catagory (file input) with column Sub Catagory(file maste…

Can you guide me for solve it?

Thank you