Previous Topic Next Topic

Compare 2 columns in 2 sheets and populate 3rd column in sheet 1

Closed
umishrikotkar Posts 1 Registration date Wednesday May 17, 2017 Status Member Last seen May 17, 2017 - Updated on May 17, 2017 at 05:54 PM
Hello,
I have following sheets. I want to populate Sheet 1 column B with value in columnB in sheet 2 where sheet 1 CA value matches with Sheet2 CA

Sheet 1
Columns A B
ab Text 2
bc
cd
ef Text 3
ze Text 4
xy Text1

Sheet 2
Columns A B
xy Text 1
ab Text 2
bc
ze Text 4
ef Text 3



Please can someone help?
Related:

Similar discussions

Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses