|
|
#8
09-01-2017, 10:50 AM
|
|||
|
|||
I actually made a serious attempt in creating the formula so it is a bit frustrating for me if it is not what you want. But it is difficult for me to understand what you write as you do not give examples of expected results (it may be due to the fact that English is not my mother tongue).
I attach a new version of the file where I have added QARVP1, QARVP2 and QARVP3 to Summary!C4:C6 and corresponding formulas in Summary!E4:E6 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel - Index and Match Function ,First Second and Third Match | paulzy95 | Excel | 10 | 09-29-2016 10:46 PM |
| Index and Match functions | aman.chauhan | Excel | 1 | 06-18-2016 02:09 AM |
| Index match vba | grexcelman | Excel | 0 | 03-05-2015 10:55 PM |
 Index Match function
|
jackzha | Excel | 5 | 12-03-2014 12:43 PM |
|
Vlookup and If conditions together along with match formulas
|
david_benjamin | Excel | 2 | 04-11-2011 11:30 AM |
Windows 10 
Office 2016
Threaded Mode