a bit more explanation might be helpful but take a look in the help index
for INDIRECT


--
Don Guillett
SalesAid Software

"NAS" wrote in message
...
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.