I would like to use lookup in formula field.
How can I make it?
Here is my Airtable.

Airtable: Organize anything you can imagine
Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.
In the Table A, the data which entered by the user via form is “a”.
Then the data will convert by a formula into “aa”.
This “aa” is the key data in the Table B.
I want to lookup the data form Table B using “aa”.
Here is the form.

Form - Airtable
Fill out the "Form" form quickly and securely on Airtable.
Thanks for your great support!