|
|
|
|
#1
11-07-2015, 04:29 AM
|
|||
|
|||
Question about Index match formula to copy all of cells in row
Hi all
Sorry I think I may have posted this in the wrong area earlier on in Excel Programing so have reposted here . I Require a formula that if cell info in sheet1 Table match's cell info in sheet 2 table then themore detail complete row is copied back to sheet 1 to the right of that name. There are several blank cells that will be copied back to the first sheet that if possible would need to remain blank with no N/A . The data in each row to be copied back to sheet 1 is combination of alpha and numerical data Sheet1 Name: RacePage Sheet2 Name: Personal Lookup value is in Cell: RacePage AZ26 Table Array to search and copy : A2:FO26 name/ data to search in is in A2:A25 cheers Dave 
|
|
#2
11-08-2015, 01:41 AM
|
||||
|
||||
|
Please post a sample sheet with some data and desired results - Thx
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| index / match Formula | dmcg9760 | Excel Programming | 1 | 11-08-2015 03:16 PM |
| Index match vba | grexcelman | Excel | 0 | 03-05-2015 10:55 PM |
 Excel Formula: return a range of cells that match
|
tinfanide | Excel | 4 | 08-30-2014 07:03 AM |
| Complex Formula using INDEX and Match needed | OTPM | Excel | 5 | 05-23-2013 01:22 AM |
| Help with multiple match and index formula | ryanwood | Excel | 1 | 09-12-2012 07:53 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode