If your droplist in column A and you make a choice in A2, you want B2
and C2 (etc) to go grab some matching date to A2 and fill it in? Like
prices and rates and availability and such?

This is a standard VLOOKUP formula. If the sheet holding the data you
want to pull information from is on Sheet2, let's say Text Desc in
column A and prices in Column B.

On Sheet1, your validation list of descriptions is in cell A2. In B2,
this formula would pull over the matching price:

=VLOOKUP(A2,Sheet2!$A2:$B$100,2,FALSE)

If there were date in column C you wanted, the formula for C2 would be

=VLOOKUP(A2,Sheet2!$A2:$C$100,3,FALSE)

Press F1 and readup on using the VLOOKUP formula.

hypnogic;174981 Wrote:
it is a data validation drop down list -- and each entry has a series of
different row values. I'd like these row values to auto-generate by
simple selection of the drop-down list item.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48377