i need a formula that searches for a value in column 1 returns the corrseponding cell in cloumn 2 in cell c6 then returns the 3 rows above the value in column 2. please see attached spreadsheet for clarification.
Find Value & Return Value x Rows Above
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!