Thread: Index Match Formulas
View Single Post
 
Old 09-01-2017, 08:31 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Just one last thing.
The formulas in Summary!E3:E6 are array formulas so please be aware that when entering such a formula you must hold down Ctrl and Shift before pressing Enter (instead of just pressing Enter). If you do it correctly Excel will put brackets around the formula {}. Don't try to enter these brackets manually. When you have entered one array formula correctly you can copy it to other cells as you normally do.
Reply With Quote