Previous Topic Next Topic

Excel Doubt

Closed
Saravanan - Jun 13, 2012 at 04:21 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 17, 2012 at 12:09 AM
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


Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jun 17, 2012 at 12:09 AM
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
0

Similar discussions

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

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response