Hello, first post here I'm a web designer not a excel expert so please bare with me.
I have two spread sheets, one is a parts list with part numbers and part name.
Sheet 1
The second is a warehouse list which has all the part numbers and locations.
Sheet 2
Now of course there are multiple part numbers in different locations so right now I have to make a new spreadsheet that counts all the unique part numbers and puts the quantity next to them.
Sheet 3
I am then putting this function in sheet1 to look up the quantities from sheet 3.
=IF(ISERROR(VLOOKUP(B2,Sheet3!A:B,2,0)),"",VLOOKUP(B2,Sheet3!A:B,2,0))
I would like to bypass the third set and just lookup the quantity from Sheet 2. Is there anyway to do this?
Bookmarks