Help merge sheets data

**deepanc** · 02-09-2013, 08:57 AM

Hi...
I have 5 sheets… Sheet1 has Name list, by use of formula =If(isblank()…. I made name would appear in all other sheets…
Now I want in “CONSOLIDATION” Sheet ( 5th sheet) all the datas of other datas would appear in correspondence column… Please download my attachment and give a formula…

(If I delete/modify a name in sheet1 the datas of that names would disappear in all other sheets including “CONSOLIDATION” Sheet. Thanks in Advance…

**alansidman** · 02-09-2013, 09:53 AM

Look at the attached. Used the Vlookup function.

Read here for more information.

http://www.techonthenet.com/excel/formulas/vlookup.php

**alansidman** · 02-09-2013, 09:54 AM

Look at the attached. Used the Vlookup function.

Read here for more information.

http://www.techonthenet.com/excel/formulas/vlookup.php

**deepanc** · 02-09-2013, 11:25 AM

[QUOTE=alansidman;3118261]Look at the attached. Used the Vlookup function.

Read here for more information.

http://www.techonthenet.com/excel/formulas/vlookup.php[

Thank You... Excellent link...