So I have a drop-down menu in **order** sheet and I have an **info** sheet.  In the info sheet, I have 2 columns, column **A** has the customer name, column **B** has the customer e-mail.

So what I'd like to do is, in the order sheet select a customer name, then the column next to it would auto-populate their e-mail address.

I have 43 customers with 43 e-mails and it's inconvenient to select the customer (IE Joe H.) and the try to find that guys e-mail from another drop-down list.  If it could auto-populate it would be nice.

Basically, I was looking at the `IF` command or `LOOKUP` command and I'm a little confused which will best suit my needs.

If column **A** in order sheets is `Joe`, then column **B** in order sheets is automatically `[email protected]`, if column **A** is `Jack` then column **B** is `[email protected]` and so on.