Matching? Or Combining?

beanyboy7

New Member
Joined
Dec 15, 2003
Messages
22
:cry:

I am getting rather frustrated with this one Excel task that I have to complete.

I have 2 seperate spreadsheetz. The first(list #1) one is names of customers and the second(list #2) is names of delinquent acounts and their phone numbers.

I have to match the names and phone #'s from list #2 with the names from list #1.

I figure its some kind of Match or lookup function, but I am just bangin my head here trying to remember what the hell it is.


:oops:
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,974
Office Version
  1. 365
Platform
  1. Windows
Take a look at the VLOOKUP function in Excel help.

Tip: Instead of referencing the sheet & range you are trying to lookup, you can name your range through Insert | Name | Define ... Then you can just use the named range in your VLOOKUP formula for the second parameter.
 

beanyboy7

New Member
Joined
Dec 15, 2003
Messages
22
I tried using the VLOOKUP function and the help menu that it automatically brings up. No such luck.

When I use it I get a N/A# message or a VALUE!# message.

Any ideas.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,974
Office Version
  1. 365
Platform
  1. Windows
Please list out the setup of these spreadsheets and post the VLOOKUP formula you have written and we can help you write it.
 

beanyboy7

New Member
Joined
Dec 15, 2003
Messages
22
The lists look like:

List#1 List#2
Names: Names: Phone#:
Smith Handel 555-5511
Jones Smith 555-9878
Daves Jones 555-7811
Roberts Martin 555-7977

Here's my fomrula
=VLOOKUP(Customers!A2:A1582,Numbers,'[SANOFI_pending_all_regdocs.Lorna.xls]No Duplicates (with Phone#''s)'!$A$2:$A$362,FALSE)


[/list]
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,974
Office Version
  1. 365
Platform
  1. Windows
OK, your VLOOKUP function is set up incorrectly.

Let's say that list one is one sheet one, with names starting in A2 and going down column A and nothing else on the sheet.

Let's say that list two is on sheet two, with names in the range A2:A100 and phone number in the range B2:B100.

Now, if you wanted to match up the phone number next to the name on sheet one, then in cell B2 enter this VLOOKUP formula:

=VLOOKUP(A2,Sheet2!A2:B100,2,FALSE)

A2 is the value you are looking up (one cell only, NOT a range of cells)
Sheet2!A2:B100 is the range you are looking in to find a match
2 means once you find a match, return the value form the 2nd column (column B)
False means only return exact matches

Then copy this formula down for all rows.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,324
Messages
5,600,956
Members
414,417
Latest member
Nobu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top