Solved

How to import source data on an existing primary field

Posted on 2011-03-08
1
230 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

863 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now