# Formula to combine data from multiple sheets to a summary sheet

1. ## Formula to combine data from multiple sheets to a summary sheet

Hello.

Currently I have 2 worksheets for 2 similar jobs; each sheet contains part numbers and the quantity needed. What I am trying to do, in a third worksheet is combine the data from BOTH jobs(summary page) so that I can easily put together purchase orders.

On "Inventory", I'd like to search "10060-01" and "10060-02" by internal part numbers (A4:A57) and have the quantity value returned to columns E(10060-01) and F(10060-02).

I've tried vlookup, but can not seem to get it to work.

I am using Excel 2010 and have attached the file for reference. Thank you!

2. ## Re: Formula to combine data from multiple sheets to a summary sheet

Hi Laurann,

welcome to the forum.

Try using below formula:-

Formula:
`Please Login or Register  to view this content.`

see attached:-
INVENTORY 10060-01-AND-02-COMBINED.xls

Regards,
DILIPandey
<click on below * if this helps>

3. ## Re: Formula to combine data from multiple sheets to a summary sheet

E3 of Inventory:
=IFERROR(VLOOKUP(A3,'10060-01'!\$A\$3:\$E\$100,5,FALSE),"")

F3 of Inventory:
=IFERROR(VLOOKUP(A3,'10060-02'!\$A\$3:\$E\$100,5,FALSE),"")

G3 of Inventory
=SUMIF(E3:F3,">0")

Drag all of them down

Hope this helps

4. ## Re: Formula to combine data from multiple sheets to a summary sheet

Yes to both of you! You've just saved future me many hours and headaches! Thank you both so very much!

5. ## Re: Formula to combine data from multiple sheets to a summary sheet

cheers

You are welcome laura

Regards,
DILIPandey
<click on below * if this helps>

6. ## Re: Formula to combine data from multiple sheets to a summary sheet

You are welcome

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1