"NAS" wrote:
I know how to make a vlookup and a dropdown list but i want to know if there
is a way to have the vlookup create a row of info but also allow a dropdown
list be in the middle of it so that you can have different options for
certain columns.

Perhaps just point the vlookup's col_index_num param to a cell which
contains the DV housing the selectable numbers: 1,2,3 ...

Eg in say, C2: =VLOOKUP(B2,MyTable,$C$1,0)
where cell C1 houses the DV to select the desired col_index_num
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---