Skip to main content
Web Applications

Return to Question

Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
added 35 characters in body; edited tags; edited title
Source Link
user0
user0
  • 27.1k
  • 10
  • 53
  • 78
added 35 characters in body; edited tags; edited title
Source Link
user0
user0
  • 27.1k
  • 10
  • 53
  • 78

if command limits LOOKUP for data from other sheet

So I have a drop down-down menu in "order"order sheet and I have a "info"an info sheet. In the info sheet, I have 2 columns, column AA has the customer name, Column Bcolumn 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-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-down list. If it could auto populate-populate it would be nice.

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

If column 'A'A in order sheets is JoeJoe, then column 'B'B in order sheets is automatically [email protected][email protected], if column 'A'A is JackJack then column 'B'B is [email protected][email protected] and so on.

if command limits

So I have a drop down menu in "order" sheet and I have a "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.

LOOKUP for data from other sheet

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.

Source Link
Galen S
Galen S
  • 31
  • 1

if command limits

So I have a drop down menu in "order" sheet and I have a "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.