Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using lookup
I have a table for Cancer Treatment and I would like to autofill a particular
field. To determine the data to place in the desired field, it must check four values (set up now as drop down lists). What I would like to see is that once the four values are chosen, it will populate the desired cell with data from the correct cell on the correct sheet. I haven't been able to figure this one out yet. There are 200 data fields possible to choose from over 4 sheets. I hope this makes sense, if not I can elaborate more. Thanks for any advice. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using lookup
Probably missing something basic here but I don't understand the basis for
selecting the sheet or the cell on the sheet. An example of the data in the drop down boxes, on each of the sheets and how you want it to work would be useful. Regards Trevor "Sweaver" wrote in message ... I have a table for Cancer Treatment and I would like to autofill a particular field. To determine the data to place in the desired field, it must check four values (set up now as drop down lists). What I would like to see is that once the four values are chosen, it will populate the desired cell with data from the correct cell on the correct sheet. I haven't been able to figure this one out yet. There are 200 data fields possible to choose from over 4 sheets. I hope this makes sense, if not I can elaborate more. Thanks for any advice. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) |