Lookup or match feature or equivalent

[Chris6]

Hi

Is there a lookup feature for formulas ie If table A cell says X look up and match on Table B

Thanks

Chris