HI ,
I have data on one spreadsheet, that I need to be able to pull parts of , across to another spreadsheet.
The data in the two sheets are not in the same order
sheet 1.jpgsheet 2.jpg
Images are attached ( hopefully) of thew two sheets I am discussing.
I need to be able to

show the stock level on sheet 1 for item number example 12119BLU
item number 12119BLU may not appear in sheet 2 so this entry could pull across and show N/A or something like that if there is no reference to it
However example item code 18020CRE shows a stock level of "0" which means i need this info as a zero appearing in the stock level column to indicate it is a product, but with no current stock

the 15117PEA would show as stock level "1" as another example of what i need to achieve
In summary column E in sheet 2
needs to pull data over into a stock level column in sheet 1
codes in sheet 2 that have no match in sheet 1 need to show N/A or something other than zero
I have tried various VLookup to no avail
My first time here so please be gentle

Hope all is clear
Rgs Rintintin