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.