| Home |
| Search |
| Today's Posts |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning a cell reference with a formula?
Thanks soooo much
This is working beautifully. It has opened a huge realm of things that I can do with the tables that I work with. Hurton "daddylonglegs" wrote: Are you attempting to find the second match for F12 and return a value in the corresponding row? This should do that =VLOOKUP(F12,INDEX(L1:L20,MATCH(F12,L1:L20,0)+1):N 36,2,0) Note that this will return a value from column M, is that what you require -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=513798 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning a cell's formula in a different cell | Excel Worksheet Functions | |||
| Cell Reference Embedded in Formula | Excel Worksheet Functions | |||
| Q: Can a formula reference a cell to get the file name to link to for data? | Excel Discussion (Misc queries) | |||
| I there an easy way to find out if any formula reference a cell? | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
