#1
|
|||
|
|||
Excel function help
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 |
#2
|
|||
|
|||
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 ? |
#3
|
|||
|
|||
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. |
#4
|
||||
|
||||
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. |
#5
|
|||
|
|||
thanks much!!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
need excel formula using if function | pulkit | Excel | 4 | 05-06-2020 01:55 AM |
Excel VBA Vlookup function help | Mark.Christian | Excel Programming | 1 | 07-19-2016 11:32 AM |
Excel function issue | Nobody | Excel | 1 | 06-30-2014 12:26 PM |
Excel Function | co-lay | Excel | 3 | 02-13-2012 03:46 PM |
Help! for using an appropriate function/Macro in Excel | pawan2paw | Excel | 1 | 06-04-2009 12:28 PM |