i need a formula to lookup a value in row 5 and return the value in row 1.
As far as i have discovered it can only lookup row 1 and return a result for
cells below.
Any help would be appreciated.