| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto fill or if function
Hi, I have a RMA form (sheet1),and I set up a customer dropdown list on
column A on sheet 2; column B and C are corresponding phone number and address. I already validated A1(sheet1) with customer list on sheet 2. When I select any customer from the dropdown list on A1, how will it automatically show its phone number on A2, address on A3, etc. using the data from sheet 2? Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto fill or if function
You should use the VLOOKUP() worksheet function. I just wrote a whole
dissertation on it in the response to this inquiry: http://www.microsoft.com/office/comm...0-55549979cf08 So please forgive me for directing you to it, but fingers are tired. See Excel Help on VLOOKUP() for more detailed information. "freebee" wrote: Hi, I have a RMA form (sheet1),and I set up a customer dropdown list on column A on sheet 2; column B and C are corresponding phone number and address. I already validated A1(sheet1) with customer list on sheet 2. When I select any customer from the dropdown list on A1, how will it automatically show its phone number on A2, address on A3, etc. using the data from sheet 2? Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto fill or if function
hi
use VLookup in A2 and A3 regards FSt1 "freebee" wrote: Hi, I have a RMA form (sheet1),and I set up a customer dropdown list on column A on sheet 2; column B and C are corresponding phone number and address. I already validated A1(sheet1) with customer list on sheet 2. When I select any customer from the dropdown list on A1, how will it automatically show its phone number on A2, address on A3, etc. using the data from sheet 2? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Fill function in Excel 2007 not working properly | Excel Worksheet Functions | |||
| Looking for some type of function to auto-fill template | Excel Discussion (Misc queries) | |||
| Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
| using auto fill edit or fill handel | Excel Worksheet Functions | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
Linear Mode
