You need two VLOOKUP formulas in two cells.

=VLOOKUP(D2, $A$2:$C$3,2,FALSE) entered in E2

=VLOOKUP(D2, $A$2:$C$3,3,FALSE) entered in F2

DV list is in D2 where you make the selection.

I'm sure you have a greater range than A2:C3 so drag the formulas in E and F
down as far as you wish.

You will need a DV dropdown in each of D2 and D3 and whatever other cells you
want a value lookup value entered.

You may want to trap in the formulas so's you don't get #N/A

=IF(ISNA(VLOOKUP(D2, $A$2:$C$3,2,FALSE),"",VLOOKUP(D2, $A$2:$C$3,2,FALSE)


Gord Dibben MS Excel MVP

On Wed, 25 Jul 2007 13:46:01 -0700, LTaylor
wrote:

I am using the VLOOKUP formula to return a value in a cell based on a
validation list. I want to know if I pick something in the list can I have
it fill in one cell with a value from one column and another cell with a
value from another column. For example:
A B C
Program Description Products
Banking At Work description 1 online, mail, etc
Internet Banking description 2 bill pay etc

I want to pick something from the program column and have the description
fill in the next column and the products fill in the one after that.

I have Column A named Program as a range a2:a3, I have description 1 named
BankingAtWork and this works with the VLOOKUP However, I don't know how to
get column C to work with VLOOKUP based on the Programs. Thank you.