| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Want A1 to receive contents of R (from MATCH()) and C (COLUMNS(R1)
2003
Need syntax (worksheet formula) Contents of 'Sheet1'R711 = "XXX" Obtained address of R711 via MATCH(A11,'Sheet1'!$A$2:$A$1031,0)+1 which returned 711 I know the column is "R" so I used COLUMNS(R1) to force 18 so Column is 18 or "R" On Sheet2 in Cell D1, I want the value "XXX" to appear which is the value in 'Sheet1'R711 How do I write the formula in Sheet2 in Cell D1 using the formulas MATCH and COLUMNS? TIA EagleOne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I combine data from two sheets where field contents match? | Excel Worksheet Functions | |||
| Table of Contents (Exact match Hyperlinks?) | Excel Worksheet Functions | |||
| How do I match and merger row contents from one workbook to anothe | Excel Discussion (Misc queries) | |||
| Can I set up excel columns that receive a checkmark? | New Users to Excel | |||
| Edit macro to match entire cell contents | Excel Discussion (Misc queries) | |||
Threaded Mode
