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!
Bookmarks