to return a value, you use the match in an INDEX

=index(sheet2!E$,match(...)) would give the value from E in sheet 2 that aligns to the searched for value in the match statement.

I was using this just this morning

Posted By: watfordcanary, Jul 29, 16:20:09