VBA or Lookup need to compare and update and select from dropdown Is it Possible

[daleholden]

Hi Guys
I have a sheet called DropShip with stock data in it
A1 SKU
F1 Total Cost
J1 Sale Price
I1 Stock Drop Down List


Located on separate sheet AllFees W1:W8
[TABLE="width: 188"]
<tbody>[TR]
[TD]In Stock -Listed
[/TD]
[/TR]
[TR]
[TD]In Stock -Stopped
[/TD]
[/TR]
[TR]
[TD]Out of Stock - Listed
[/TD]
[/TR]
[TR]
[TD]Out of Stock - Stopped
[/TD]
[/TR]
[TR]
[TD]Out of Stock - Removed
[/TD]
[/TR]
[TR]
[TD]Discontinued - Stopped
[/TD]
[/TR]
[TR]
[TD]Discontinued - Removed
[/TD]
[/TR]
[TR]
[TD]Back Order - Stopped
[/TD]
[/TR]
[TR]
[TD]Back Order - Removed
[/TD]
[/TR]
</tbody>[/TABLE]


Live data sheet from suppler called New Data
A1 SKU
G1 Total Cost
H1 Sale Price
I1 Report =In Stock, Out of Stock, No Longer Listed
I need a solution to for everytime I update / refresh data on NewData sheet the prices are checked against the Sku and the prices updated to the new values in F1 & J1. Also check stock level
If it report In Stock do nothing
If it report Out of Stock update to show ‘Out of Stock – Stopped’
If it reports No Longer Listed to show ‘Discontinued – Stopped’

Please note DropShip is an Excel table and wil grow
NewData not a table but grows as well

Please can you tell me if it is possible and how can i complete it

Cheers Dale