Matching? Or Combining?

[beanyboy7]

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.

 

[Joe4]

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]

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]

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

 

[beanyboy7]

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]

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.