Hello Friends Firstly Wish you a very happy new.
i am little bit confused. I have use excel2007.
I have file with three sheet.
Sheet1 : Name1 / Name2 / Address / City / Country (Column A/B/C/D/E)
Sheet2 : Name / Depend / Connection (Column A/B/C)
In sheet2 i merged Name with sheet1 Name1&" "&Name2
Sheet3 : Name1 / Name2 / Address / City / Country / Wife / Son1 / Son2 (Column A/B/C/D/E/F/G/H)
In Sheet3 : I required result in column "F" / "G" / "H" which is in Sheet2 data Who of Depend (Dependend Name) column "B" but match with column "C" connection (Wife /Son).
Required result shown in attach file which is highlighted in yellow.
i am little bit confused. I have use excel2007.
I have file with three sheet.
Sheet1 : Name1 / Name2 / Address / City / Country (Column A/B/C/D/E)
Sheet2 : Name / Depend / Connection (Column A/B/C)
In sheet2 i merged Name with sheet1 Name1&" "&Name2
Sheet3 : Name1 / Name2 / Address / City / Country / Wife / Son1 / Son2 (Column A/B/C/D/E/F/G/H)
In Sheet3 : I required result in column "F" / "G" / "H" which is in Sheet2 data Who of Depend (Dependend Name) column "B" but match with column "C" connection (Wife /Son).
Required result shown in attach file which is highlighted in yellow.