Cell on Cell interaction help
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. |
Cell on Cell interaction help
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. |
All times are GMT +1. The time now is 11:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com