I've created this formula below by concatenating it together from other cells. But how can I quickly run the formula (maybe with a keyboard shortcut?). It will not automatically run even when automatically formula calculation is selected in excel options. The only way to get it to run is to double-click inside the cell, then hit enter. But I'd like to do this for a large range.
Maybe a keyboard shortcut that runs the checkmark next to the FX button?
=VLOOKUP(Z2,S27:U27,3,FALSE)
Maybe a keyboard shortcut that runs the checkmark next to the FX button?
=VLOOKUP(Z2,S27:U27,3,FALSE)