Hi All,



I need help to generate data from sheet 2 to sheet 1 columns (D, E) using excel function.

I have tried some functions but still not get correct data.

Please refer the attached workbook and help on this!!

in Sheet1, row 4 data incorrectly pulled out from sheet 2 which need to be fixed using function.

Thanks
Ganesan. G

Attached Files

Book1.xlsx (9.7 KB, 10 views)

Your workbook is a little scant on data.


And if you're asking for assistance with macros, shouldn't you be posting an .xlsm file ?

Thanks for reply.

I have the similar data for other rows like this attachment and i have attached the excel template file.

Please check advise.

Attached Files

Book1.xltm (11.4 KB, 8 views)

Either:
in cell D2:
=INDEX(Sheet2!C$2:C$11,MATCH($A2 & "¬" & $C2,Sheet2!$A$2:$A$11 & "¬" & Sheet2!$B$2:$B$11,0))
in cell E2:
=INDEX(Sheet2!D$2:D$11,MATCH($A2 & "¬" & $C2,Sheet2!$A$2:$A$11 & "¬" & Sheet2!$B$2:$B$11,0))
both copied down
or if your version of Excel supports the FILTER function, in cell D2:
=FILTER(Sheet2!$C$2:$D$11,(Sheet2!$A$2:$A$11=A2)*( C2=Sheet2!$B$2:$B$11),"Not found")
copied down.

thanks much!!