Excel corelated data into Another Sheet

Help Activities
, , , ,
1

Hi Everyone,
I have a scenario in Excel. I have 2 sheets of data Based on 1st sheet company name, i need to get the rows of matching company and paste them in 3rd sheet.
i’m attaching the Excel for reference
Input sheets : Portal, Internal Website
OutPut Sheet : Final OutPut

Portal Sheet company name need to look in Internal Website Sheet and Matching rows need to Paste in Final Output sheet

Merge sheets data.xlsx (13.7 KB)

In Output Sheet - Company, Job Location,Position, Job Posting Links - These columns data are taking from PORTAL sheet.

2

Hi @Learner007,

Please find the solution attached. I have written the output in Sheet1. Also, added all the columns from Internal Website sheet in the output.

You can rename the column name and set ordinal positions according to your requirement.

TEST1.zip (15.5 KB)

Cheers

1 Like
3

Hi @Gayathri_Ramanathan there is an error i was getting when no rows are matched. i modified and fixed that. Rest everything is working Fine. Thanks for the Solution.

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.