VBA to provide a MATCH Function from different sheets

[hemal89]

Hi all,

I am currently facing a problem which I have had no luck in resolving on my own, so all help provided will be much appreciated.

1) I need to match Sheet1 columns D-J cell contents (numerical values) to a column A in Sheet2

2) If the values match I then need to replace the cell contents of the corresponding cell in Column B in Sheet2 with the value from Column C in Sheet1

E.g. To aid understanding

Sheet 1:
Column C
Catagory 1
Catagory 2
Catagory 3
ect

Columns D-J
1.1
1.3
22.5
10.6
ect

Sheet 2
Column A
1.1
1.3
10.6
22.5
ect

Column B
Catagory 1
Catagory 2
Catagory 3
ect

I have currently done something similar to provide custom conditinal formatting please see formula below for reference:
=ISNA(MATCH(D2:J2,Sheet2!$A:$A,0)) - RED
=MATCH(D2:J2,Sheet2!$A:$A,0)<>0 - GREEN

Many Thanks,

H

[LokeshKumar]

can you upload the workbook?

[hemal89]

Hi,

Thanks for your reply,

Please see attached for a example workbook....I ahd to delete some sensitive information so the column letetrs are now slightly different.

let me know if you need further explanation of the problem.

H

[LokeshKumar]

Hi
Sorry for late reply.. use this:-

Please Login or Register  to view this content.

Example Workbook1.xlsx