New Sheet need help on Lookup on two sheets is possible

[daleholden]

Hello Guys

Need some help please not sure if it is possible but i think it may be.

I am knocking together a new SS covering Stock on two separate sheets (they need to be several different fields but some the same)

I have a sales sheet A1 i want to add a SKU number in which i want Excel to go off and search 2 separate sheets (Own Stock, DropShip) in same workbook.
If it is possible i want it to drag back data from the sheet the SKU matches

I have created a separate sheet to hold all the list and % figures.I have added dropdown to select an option and from the option it selects i want it to perform a calculation. Not sure if it can be in the same cell or select from dropdown in one cell calculation in next cell???

I will have several questions to get the sheet working no doubt but if i start at beginning it may be easier to help.

So i enter SKU DS1234 excel goes off and looksup on two sheets when it finds a match it drags back

1. Product name
2. Product Cost
3. eBay Price
4. ebay Category
5. ebay FVF

I then have 3 drop downs to select an item and from that selection o need excel to look that selection and grab the percentage and work out the price from ebay price.

Hope this helps

See data list https://dl.dropboxusercontent.com/u/92887/List Data.jpg
Sales Sheet https://dl.dropboxusercontent.com/u/92887/Sales Sheet.jpg
Stock Sheet https://dl.dropboxusercontent.com/u/92887/Stock Sheet.jpg
Dale