I know I should remember how to do this but I don't :-)

Given a table of data I want a formula to look for a value within the table
and return a second value from a prescribed column on the same row.

As a Second formula to also return a value from a prescribed row in the same
column as the search value.

Thanks Aitchy