#1
|
|||
|
|||
index / match Formula
Hi all
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 Last edited by dmcg9760; 11-06-2015 at 10:57 PM. Reason: more datail |
#2
|
||||
|
||||
Kindly don't post the same question multiple times.
Thread closed.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Translate INDEX(MATCH) into VBA | grexcelman | Excel Programming | 1 | 03-08-2015 05:06 PM |
Index match vba | grexcelman | Excel | 0 | 03-05-2015 10:55 PM |
UDF multiple IFs INDEX-MATCH | grexcelman | Excel Programming | 0 | 02-22-2015 04:20 PM |
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 |