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

S

ssciarrino

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.
 
B

Bob Phillips

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)
 
S

ssciarrino

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
 
Top