Matching? Or Combining?

beanyboy7

New Member

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.

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
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.

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.

Please list out the setup of these spreadsheets and post the VLOOKUP formula you have written and we can help you write it.

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]

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.

Replies
1
Views
326
Replies
17
Views
444
Replies
7
Views
377
Replies
4
Views
110
Replies
2
Views
80

1,218,699
Messages
6,143,960
Members
450,519
Latest member
nashat

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.

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

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