Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup table
I have a company name, contact name, and phone number table. Can I us the
lookup formula to fill in the contact name and phone number once I type the company name. What do I do when there are various contacts for a company and I want the phone number to automatically fill in for that contact. -- Sherrya |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup table
This all depends on how your table is setup.
You'd need to describe in *great detail* how the table is setup. -- Biff Microsoft Excel MVP "Sherrya" wrote in message ... I have a company name, contact name, and phone number table. Can I us the lookup formula to fill in the contact name and phone number once I type the company name. What do I do when there are various contacts for a company and I want the phone number to automatically fill in for that contact. -- Sherrya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TOP Value in Lookup Table | Excel Discussion (Misc queries) | |||
Lookup value in table | Excel Worksheet Functions | |||
Lookup Table help | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Help with lookup table | Excel Worksheet Functions |