Function Help

  • Thread starter Thread starter Nancy
  • Start date Start date
N

Nancy

Any help would be appreciated on this. Here's my issue.

I need to do some type of look-up between 2 spreadsheets.
The first spreadsheet is a list of zip codes and reps
assigned to those zips. Column A is the zip and column B
is a reps name.

Example
77002 Bob
77003 Jane

My second spreadsheet is a list of companies that in a
single column, for example column D contains the zip
code.

What I would like to do is write some type of function
that starts with the zip code column is spreadsheet b,
looks to spreadsheet A to match the zip code, then when
the match is found, the rep name would then be copied to a
column back in spreadsheet B.

Any help would be greatly appreciated.
 
Sheet1 reps and zips
Sheet2 companies and otherstuff and zips (in column D)

in column E

=VLOOKUP($D$1,'sheet1'!$A$1:$B$65536,2,"false")

copy this as far down as necessary.

$D$1 is the cell containing the first company's zip
$A$1:$B$65536 is the area on sheet1 containing the info
about the reps.

Change those to match your layout.

Good Luck
Drabbacs
 
Back
Top