Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
return valuve
hi all,
help please if the ADDRESS of a cell is produced by the formula =ADDRESS(MATCH(A2&"*",B:B,0),2,4) . Say for example B251 , how can I return the value of this address. many thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
return valuve
=INDEX(B:B,MATCH(A2&"*",B:B,0))
Looks like it should work. excelFan wrote: hi all, help please if the ADDRESS of a cell is produced by the formula =ADDRESS(MATCH(A2&"*",B:B,0),2,4) . Say for example B251 , how can I return the value of this address. many thanks -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
return valuve
Hi!
Either: =INDEX(B:B,MATCH(A2&"*",B:B,0)) =INDIRECT(ADDRESS(MATCH(A2&"*",B:B,0),2,4)) Biff "excelFan" wrote in message ... hi all, help please if the ADDRESS of a cell is produced by the formula =ADDRESS(MATCH(A2&"*",B:B,0),2,4) . Say for example B251 , how can I return the value of this address. many thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
return valuve
thanks Dave, works fine
"Dave Peterson" wrote: =INDEX(B:B,MATCH(A2&"*",B:B,0)) Looks like it should work. excelFan wrote: hi all, help please if the ADDRESS of a cell is produced by the formula =ADDRESS(MATCH(A2&"*",B:B,0),2,4) . Say for example B251 , how can I return the value of this address. many thanks -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
return valuve
Some others
=Indirect(ADDRESS(MATCH(A2&"*",B:B,0),2,4)) or =Offset($B$1,MATCH(A2&"*",B:B,0)-1,0) -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... =INDEX(B:B,MATCH(A2&"*",B:B,0)) Looks like it should work. excelFan wrote: hi all, help please if the ADDRESS of a cell is produced by the formula =ADDRESS(MATCH(A2&"*",B:B,0),2,4) . Say for example B251 , how can I return the value of this address. many thanks -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
return valuve
thanks Biff, that's also work fine
"Biff" wrote: Hi! Either: =INDEX(B:B,MATCH(A2&"*",B:B,0)) =INDIRECT(ADDRESS(MATCH(A2&"*",B:B,0),2,4)) Biff "excelFan" wrote in message ... hi all, help please if the ADDRESS of a cell is produced by the formula =ADDRESS(MATCH(A2&"*",B:B,0),2,4) . Say for example B251 , how can I return the value of this address. many thanks |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
return valuve
thanks Tom, this also do the job
"Tom Ogilvy" wrote: Some others =Indirect(ADDRESS(MATCH(A2&"*",B:B,0),2,4)) or =Offset($B$1,MATCH(A2&"*",B:B,0)-1,0) -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... =INDEX(B:B,MATCH(A2&"*",B:B,0)) Looks like it should work. excelFan wrote: hi all, help please if the ADDRESS of a cell is produced by the formula =ADDRESS(MATCH(A2&"*",B:B,0),2,4) . Say for example B251 , how can I return the value of this address. many thanks -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
return valuve
You're welcome!
Biff "excelFan" wrote in message ... thanks Biff, that's also work fine "Biff" wrote: Hi! Either: =INDEX(B:B,MATCH(A2&"*",B:B,0)) =INDIRECT(ADDRESS(MATCH(A2&"*",B:B,0),2,4)) Biff "excelFan" wrote in message ... hi all, help please if the ADDRESS of a cell is produced by the formula =ADDRESS(MATCH(A2&"*",B:B,0),2,4) . Say for example B251 , how can I return the value of this address. many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
help with index to return particular cell value | Excel Discussion (Misc queries) | |||
annualized return calculation for the purpose of portfolio performance evaluation | Excel Worksheet Functions | |||
check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions |