Home |
Search |
Today's Posts |
#1
|
|||
|
|||
using the LOOKUP function
Does anyone know how to use excel to look up and return values in 3 columns
to designated cells? Specifically, I have 3 columns of data...column A contains the numbers 1 through 10; column B contains certain data; column C contains more data. I need 3 drop down boxes that will allow me to choose the following: the first drop down box will allow me to choose either column B's data or column C's data. The other 2 drop down boxes will allow me to choose a number 1 through 10. In this example, if I choose column B in the first drop down box, the number 3 in the second box, and the number 5 in the third box the result will be that the corresponding values in cells B3 and B5 will populate 2 SEPARATELY DESIGNATED cells. Alternatively, if I chose column C for the first box, along with the number 3 in the second box and the number 5 in the third box, the result would be the corresponding values in cells C3 and C5 would populate two cells that I would have designated. |
#2
|
|||
|
|||
using the LOOKUP function
Use Data Validation with a list of B & C in the first, and a list of
1,2,3,...,10 in the second and third. Assuming that the DV cells are M1, M2, M3, the designated cells then use the formula =INDIRECT(M1&M2) and =INDIRECT(M1&M3) -- HTH RP (remove nothere from the email address if mailing direct) "graph" wrote in message ... Does anyone know how to use excel to look up and return values in 3 columns to designated cells? Specifically, I have 3 columns of data...column A contains the numbers 1 through 10; column B contains certain data; column C contains more data. I need 3 drop down boxes that will allow me to choose the following: the first drop down box will allow me to choose either column B's data or column C's data. The other 2 drop down boxes will allow me to choose a number 1 through 10. In this example, if I choose column B in the first drop down box, the number 3 in the second box, and the number 5 in the third box the result will be that the corresponding values in cells B3 and B5 will populate 2 SEPARATELY DESIGNATED cells. Alternatively, if I chose column C for the first box, along with the number 3 in the second box and the number 5 in the third box, the result would be the corresponding values in cells C3 and C5 would populate two cells that I would have designated. |
#3
|
|||
|
|||
using the LOOKUP function
Thank you.
"Bob Phillips" wrote: Use Data Validation with a list of B & C in the first, and a list of 1,2,3,...,10 in the second and third. Assuming that the DV cells are M1, M2, M3, the designated cells then use the formula =INDIRECT(M1&M2) and =INDIRECT(M1&M3) -- HTH RP (remove nothere from the email address if mailing direct) "graph" wrote in message ... Does anyone know how to use excel to look up and return values in 3 columns to designated cells? Specifically, I have 3 columns of data...column A contains the numbers 1 through 10; column B contains certain data; column C contains more data. I need 3 drop down boxes that will allow me to choose the following: the first drop down box will allow me to choose either column B's data or column C's data. The other 2 drop down boxes will allow me to choose a number 1 through 10. In this example, if I choose column B in the first drop down box, the number 3 in the second box, and the number 5 in the third box the result will be that the corresponding values in cells B3 and B5 will populate 2 SEPARATELY DESIGNATED cells. Alternatively, if I chose column C for the first box, along with the number 3 in the second box and the number 5 in the third box, the result would be the corresponding values in cells C3 and C5 would populate two cells that I would have designated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Function help | Excel Discussion (Misc queries) | |||
Lookup Function Problems | Excel Worksheet Functions | |||
Complicated lookup function | Excel Worksheet Functions | |||
lookup function 1 | Excel Worksheet Functions | |||
How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions |