| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to concatenate a value in cell
Hi
I am using Match worksheet function to get the cell#, Ex: my function returns me '10'. this is the cell# where the match is found. suppose the cell a10 I want to use the number returned '10' and concatenate with 'd' to make it 'd10' to get the value of cell d10. When I write the formula ' = a & match(193,a1:a20), it does not work. please advise if there is another way to do this. What I want is to look for the nearest value '193' in the cell range a1:a20 and suppose it was cell # a10 that had this value, then I want to capture the value in cell 'd10'. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to concatenate a value in cell
try
=index(D1:D20,match(193,a1:a20)) "ub" wrote: Hi I am using Match worksheet function to get the cell#, Ex: my function returns me '10'. this is the cell# where the match is found. suppose the cell a10 I want to use the number returned '10' and concatenate with 'd' to make it 'd10' to get the value of cell d10. When I write the formula ' = a & match(193,a1:a20), it does not work. please advise if there is another way to do this. What I want is to look for the nearest value '193' in the cell range a1:a20 and suppose it was cell # a10 that had this value, then I want to capture the value in cell 'd10'. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to concatenate a value in cell
=INDIRECT("D"&MATCH(193,A1:A20,0))
HTH, Paul "ub" wrote in message ... Hi I am using Match worksheet function to get the cell#, Ex: my function returns me '10'. this is the cell# where the match is found. suppose the cell a10 I want to use the number returned '10' and concatenate with 'd' to make it 'd10' to get the value of cell d10. When I write the formula ' = a & match(193,a1:a20), it does not work. please advise if there is another way to do this. What I want is to look for the nearest value '193' in the cell range a1:a20 and suppose it was cell # a10 that had this value, then I want to capture the value in cell 'd10'. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to concatenate a value in cell
I just realized you said you wanted to find the nearest value (not exact).
=INDIRECT("D"&MATCH(193,A1:A20)) "PCLIVE" wrote in message ... =INDIRECT("D"&MATCH(193,A1:A20,0)) HTH, Paul "ub" wrote in message ... Hi I am using Match worksheet function to get the cell#, Ex: my function returns me '10'. this is the cell# where the match is found. suppose the cell a10 I want to use the number returned '10' and concatenate with 'd' to make it 'd10' to get the value of cell d10. When I write the formula ' = a & match(193,a1:a20), it does not work. please advise if there is another way to do this. What I want is to look for the nearest value '193' in the cell range a1:a20 and suppose it was cell # a10 that had this value, then I want to capture the value in cell 'd10'. Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to concatenate a value in cell
actually to answer your question
=indirect("D"&match(193,a1:a20)) "ub" wrote: Hi I am using Match worksheet function to get the cell#, Ex: my function returns me '10'. this is the cell# where the match is found. suppose the cell a10 I want to use the number returned '10' and concatenate with 'd' to make it 'd10' to get the value of cell d10. When I write the formula ' = a & match(193,a1:a20), it does not work. please advise if there is another way to do this. What I want is to look for the nearest value '193' in the cell range a1:a20 and suppose it was cell # a10 that had this value, then I want to capture the value in cell 'd10'. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to concatenate a column into one cell? tia sal2 | Excel Discussion (Misc queries) | |||
| Concatenate into 1 cell and drop down lines? | Excel Discussion (Misc queries) | |||
| How to concatenate a url and the value of another cell | New Users to Excel | |||
| concatenate cell | Excel Worksheet Functions | |||
| concatenate cell and referncing afterwads | Excel Discussion (Misc queries) | |||
Linear Mode
