Pulling data from one spreadsheet to another

**rintintin** · 08-17-2013, 07:09 PM

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.jpg sheet 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

**FDibbins** · 08-17-2013, 07:17 PM

Hi and welcome to the forum

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you

**rintintin** · 08-17-2013, 07:23 PM

also I just need to see where I can upload a sample of the spreadsheet if you can help with that too?
thanks in advance

**FDibbins** · 08-17-2013, 07:24 PM

Sorry, meant to add that....
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.