I have one workbook with 2 sheets. On sheet 1 there is a drop down where the
user selects A, B, C, D, E or F. On the 2nd work sheet there are two numbers
associated with A, B, C, D, E, or F. Selecing a letter on the 1st sheet
should populate two adjacent cells with the data from the second sheet.

Can someone here help me set this up?

thank you.

See this short video:

http://contextures.com/xlVideos08.html#VLookup01

--
Biff
Microsoft Excel MVP


"Tim" wrote in message
...
I have one workbook with 2 sheets. On sheet 1 there is a drop down where
the
user selects A, B, C, D, E or F. On the 2nd work sheet there are two
numbers
associated with A, B, C, D, E, or F. Selecing a letter on the 1st sheet
should populate two adjacent cells with the data from the second sheet.

Can someone here help me set this up?

thank you.