Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
On the same spreadsheet, I have two segments of data: the first segment (A1:H19) uses the data from the second segment (B22:H90) for calculations. B2 will select a value from the drop down list it contains (based on B22:B90). When B2 is selected, I want the value in C2 to change, according to the corresponding value in C22:C90. I cannot for the life of me get it right with vlookup. Can anybody please help. Much obliged |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple VLOOKUP problem | Excel Worksheet Functions | |||
Simple lookup - or maybe not so simple - help! | Excel Worksheet Functions | |||
I need help with a simple vlookup formula | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Make it more simple or intuitive to do simple things | Charts and Charting in Excel |