I have been struggling with an Excel problem that is driving me carzy. I am
trying to design a PO request form (called Form) where I have a list of 12
buildings on another sheet (called Data) in column A. The list works great.
What I am trying to do is bring up the list on the Form sheet, click the
building name to bring up the number of the building in column B. I'm sorry
if this is hard to understand but I want to bring up the list on the Form
sheet choose the building and the building number appears in the cell.
Thanks, can anyone help?

Hi,

To create the drop down on the first sheet to read the list of names on the
other sheet you must range name the list of names. Suppose you want to call
them Buildings - select the range for example A1:A12 and click in the Name
Box (left side of the Formula Bar, where you normally cell the active cell's
address), type the name (no spaces) and press Enter.

Now move to the first sheet and set up a data validation, List and in the
Source box enter =Buildings

To bring back the building number use VLOOKUP(A1,Sheet2!A1:B12,2,)

Where A1 is the cell with the data validition results, and A1:B12 is the
list of buildings with their number in column B of the second sheet.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Leaflet" wrote:

I have been struggling with an Excel problem that is driving me carzy. I am
trying to design a PO request form (called Form) where I have a list of 12
buildings on another sheet (called Data) in column A. The list works great.
What I am trying to do is bring up the list on the Form sheet, click the
building name to bring up the number of the building in column B. I'm sorry
if this is hard to understand but I want to bring up the list on the Form
sheet choose the building and the building number appears in the cell.
Thanks, can anyone help?

Hi Shane,
Thanks for your response. One more question: where would I enter the
VLOOKUP formula?
Leaflet

"Shane Devenshire" wrote:

Hi,

To create the drop down on the first sheet to read the list of names on the
other sheet you must range name the list of names. Suppose you want to call
them Buildings - select the range for example A1:A12 and click in the Name
Box (left side of the Formula Bar, where you normally cell the active cell's
address), type the name (no spaces) and press Enter.

Now move to the first sheet and set up a data validation, List and in the
Source box enter =Buildings

To bring back the building number use VLOOKUP(A1,Sheet2!A1:B12,2,)

Where A1 is the cell with the data validition results, and A1:B12 is the
list of buildings with their number in column B of the second sheet.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Leaflet" wrote:

I have been struggling with an Excel problem that is driving me carzy. I am
trying to design a PO request form (called Form) where I have a list of 12
buildings on another sheet (called Data) in column A. The list works great.
What I am trying to do is bring up the list on the Form sheet, click the
building name to bring up the number of the building in column B. I'm sorry
if this is hard to understand but I want to bring up the list on the Form
sheet choose the building and the building number appears in the cell.
Thanks, can anyone help?