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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
help with a vlookup 2
Macro for comparing columns and highlighting matching/differences 14
How to have a drop down selection list 2
Excel VBA 1
Consistent Sheet column header rows 2
Sumproduct function allow a lookup for one Date to check if it fallsin Date Range in other table 9
Selective data validation list 1

Back
Top