Prev: Get Data from Quickbooks
Next: Does a HasDependents = True property exist?
From: freebee on 12 Apr 2010 21:16
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.

From: JLatham on 12 Apr 2010 21:41
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/community/en-us/default.mspx?dg=microsoft.public.excel.worksheet.functions&mid=c2788f3e-2110-4b2e-afe0-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.
>
From: FSt1 on 12 Apr 2010 21:46
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.
>
 | 
Pages: 1
Prev: Get Data from Quickbooks
Next: Does a HasDependents = True property exist?