Solved

How to import source data on an existing primary field

Posted on 2011-03-08
1
234 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
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…

733 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