Excel Doubt

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I am using excel 2003 and pl help me to solve the below issue

I want to compare two cells from one worksheet to other to write value

Ex
Ist worksheet
A B C
100 XYZ
200 SDE


2nd worksheet

A B C

100 XYZ 20/06/10
100 QWE 21/06/10
200 ERTT 14/5/10
200 ASD 11/5/10
200 SDE 11/5/10

In the 1st worksheet A & B column match with 2nd worksheet, then the C column value should be written in C column of 1st worksheet.

Kindly help


1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
sheet 1 data is from A1 to B2
sheet 2 data is fro A1 to C5

now n sheet1 in C1 copy this formula

=TEXT(INDEX(Sheet2!$C$1:$C$5,MATCH(1,(Sheet2!$A$1:$A$5=Sheet1!A1)*(Sheet2!$B$1:$B$5=Sheet1!B1),1)),"dd-mmm-yy")


now INVOKE THIS FORMULA BY CONTROL SHIFT ENTER

copy C1 down