Inserting data

[atencorps]

Hi ,

I require some help on an excel problem to do with the spreadsheet attached.



In the worksheet called "gaps" . Thus I know how to do a drop down list to be able to select and load data into one specific field. how do i do it so that if ie on "gaps worksheet" I drop down the list field to select REQ ID 1 - But then having selected the Req ID I want to be able to automatically "title req1 " inserted into the next available field which is B2 ,and also inserting into B3 the description for Req1.


Thanks in advance

[manny_cb]

use data validation in column A to select the value (i.e the drop down)
in column B and C use VLOOKUP


in b2: =VLOOKUP($A2,Requirements!$A$2:$C$4,2,FALSE)
in c2: =VLOOKUP($A2,Requirements!$A$2:$C$4,3,FALSE)

fill down

[atencorps]

Hi

Thanks for the reply.

Ill try it when I get to the once in the morning. So im guessing that on the gaps worksheet if I select into A2 the values for Reg 1 it will insert Reg1 title and description. Will that also work if I were to select from reg 2 or reg 3 instead ? ( ie inserting reg 2 title/description if reg 2 id is chosen instead , and same for reg 3 ? )

thanks