| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting a value from a cell that is determined by a formula
I used the Match function to find a specific value in a column of values. The
function tells me that I found the specific value in row 21. I now want to go to column w and get the value in w21. However, I can't seem to find anywhere how I could use the value determined with the match function and attach it to the letter w to get w21. The specific value in my column list can varry so I need to be able to search for the value with match and then go get another piece of information from column w based on the value found from Match. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Getting a value from a cell that is determined by a formula
=INDEX(W1:W100,YourMatchFunction)
Change W110 to suit your case -- Kind regards, Niek Otten Microsoft MVP - Excel "carl43m" wrote in message ... |I used the Match function to find a specific value in a column of values. The | function tells me that I found the specific value in row 21. I now want to | go to column w and get the value in w21. However, I can't seem to find | anywhere how I could use the value determined with the match function and | attach it to the letter w to get w21. The specific value in my column list | can varry so I need to be able to search for the value with match and then go | get another piece of information from column w based on the value found from | Match. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Getting a value from a cell that is determined by a formula
=INDIRECT("W"&formula)
replace formula with your match function that returns 21. "carl43m" wrote: I used the Match function to find a specific value in a column of values. The function tells me that I found the specific value in row 21. I now want to go to column w and get the value in w21. However, I can't seem to find anywhere how I could use the value determined with the match function and attach it to the letter w to get w21. The specific value in my column list can varry so I need to be able to search for the value with match and then go get another piece of information from column w based on the value found from Match. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Getting a value from a cell that is determined by a formula
<W110
W100 of course -- Kind regards, Niek Otten Microsoft MVP - Excel "Niek Otten" wrote in message ... | =INDEX(W1:W100,YourMatchFunction) | | Change W110 to suit your case | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | | "carl43m" wrote in message ... ||I used the Match function to find a specific value in a column of values. The || function tells me that I found the specific value in row 21. I now want to || go to column w and get the value in w21. However, I can't seem to find || anywhere how I could use the value determined with the match function and || attach it to the letter w to get w21. The specific value in my column list || can varry so I need to be able to search for the value with match and then go || get another piece of information from column w based on the value found from || Match. | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| assign formula to another cell | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| How do I set a cell value based on a formula in another cell? | Excel Discussion (Misc queries) | |||
Linear Mode
