Selecting a value in one field will result in the output another f

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ssciarrino - 27 Jan 2006 16:39 GMT

I have a worksheet.

Column 1 is the Expense, Column 2 is the Expense Description.

Column 1 I have it set for Validation List.

A hidden worksheets is a data link to a SQL server table that contains the
master expense list. Sheet1 references this hidden sheet with its validation
list.

When the user selects a value from the validation list in Column 1, I want
its corresponding description to appear in Column 2

Not sure how to achieve this and what if any function to use.

Reply to this Message

Bob Phillips - 27 Jan 2006 16:55 GMT

This is a job for VLOOKUP.

Something like

=VLOOKUP(A1,'Hidden Sheet'!A1:M10,2,False)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

> I have a worksheet.
>
[quoted text clipped - 10 lines]
>
> Not sure how to achieve this and what if any function to use.

Reply to this Message

ssciarrino - 27 Jan 2006 17:23 GMT

Hi Bob,

I am afraid this does not work the VLOOKUP command wants a parameter of for
column 1 (i.e. the actual expense ID in its formula)

I need a formula that does when users select 'Expense1' , 'Expense1
Description' appears.

Is there any formula for this?

Thanks

> This is a job for VLOOKUP.
>
[quoted text clipped - 25 lines]
> >
> > Not sure how to achieve this and what if any function to use.

Reply to this Message

ssciarrino - 27 Jan 2006 19:16 GMT

Nevermind Bob I was wrong I got it thanks for the help!

> Hi Bob,
>
[quoted text clipped - 37 lines]
> > >
> > > Not sure how to achieve this and what if any function to use.

Reply to this Message