I need to input a formula into Sheet1, that searches for a value in Sheet2 (C5:C56) that is present in Sheet1 (defined cell, C5), and then if "true", enter the value that's in the same row as the value has been found in Sheet2 but from column E.
e.g. sheet1 the set value is A. Search Sheet to C5:C56 for "A" and if found (say C35) then enter cell value of E35
Solved by Z. S. in 20 mins