LOOKUP from another sheet, newbie, Phone Contacts/Calls

Okay so this is my first post and really am only looking for one piece of information.

I have all my contacts as well as my fiance's phone contacts ...which I would like to put into a Database of some sort or another excel sheet/workbook.

With that I would download our Verizon Wireless excel sheet...which has all the numbers listed but no names. To avoid constant referencing, I would like to bounce the number off a DB/Excel file and have it return the Name of that person in a column, in the same row as that number called on that particular row.

If anyone knows what steps i need to take or has an example that i can simply modify this would be great! Thanks a ton guys, I'd love to give you feedback on your profile if you can help!!!

frogmanv,

Welcome to the Excel Forum.

You may be able to use VLOOKUP, or INDEX MATCH, depending on how your DB sheet is organized.

Please post your workbook with both worksheets (or a sample without sensative information).

Click on the New Post button, then scroll down and click on the Manage Attachments button.

Frogman, please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

frogmanv,

In worksheet Month 1, copy the below formula into cell F2, and copy it down:

=IF(ISNA(INDEX('Contacts List'!A:A,MATCH($C2,'Contacts List'!B:B,0))),"",INDEX('Contacts List'!A:A,MATCH($C2,'Contacts List'!B:B,0)))