Solved

How to import source data on an existing primary field

Posted on 2011-03-08
1
232 Views
Last Modified: 2012-05-11

My source file contains the exact city / lot number which coressponds to an exact device number.

I want to take my existing spreadsheet and have all city/lot numbers sync with that of my source file.

So spreadsheet A; ROW 01 would now contain the same device number as Spreadsheet B; ROW 01 and so forth.
If possible I would like to have all fields within this column print the word null if there is no source data for that city /lot
from Worksheet B.

Is this done with a vlookup? I have been trying but to no avail

Yellow cell on worksheet A is what I am trying to pull over from the source worksheet
vlookup-example-devicenum.xlsx
0
Comment
Question by:manelson05
1 Comment
 
LVL 13

Accepted Solution

by:
gamarrojgq earned 500 total points
ID: 35070188
Hi,

You can do it with this formula

=IF(ISERROR(VLOOKUP(B2,'B - SOURCE'!$A$2:$B$378,2,FALSE)),"null",VLOOKUP(B2,'B - SOURCE'!$A$2:$B$378,2,FALSE))
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

806 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question