| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
use the result of match function as a part of row address
I want to use the result of match function as a part of row address.
that is; if "=MATCH(B7,$B$1:$B$7,0)" gives 3 then $a$(MATCH(B7,$B$1:$B$7,0)) things like that. is it possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search spreadsheet for 'xyz' as part of any hyperlink address | Excel Discussion (Misc queries) | |||
| VLOOKUP with cell address as part of the argument | Excel Discussion (Misc queries) | |||
| Using address function result in an array | Excel Worksheet Functions | |||
| Replace part of link address in a cell with a value(date) from ano | Excel Discussion (Misc queries) | |||
| Using result from ADDRESS function as a cell reference itself | Excel Worksheet Functions | |||
Threaded Mode
