Not sure what to call this
 

What I'm looking to do is populate one field with data when another
equals certain variables.

For instance:
Column B has the variable data and Column BA has the destination or
place I want to populate the data.

If Column B reads Widgets then I want Column BA to read parts, widgets
If Column B reads Small widgets then I want Column BA to read parts,
small widgets

I have quite a few variables for Column B, but I know what the output
should be in BA. Problem is
I have over 1200 data entries and I want some help to populate these
entries.

How do I go about doing this??


Thanks

Not sure what to call this
 

Hi

Insert this in BA2 and copy it down as required:

="Parts, " & B2

Hopes this helps.
....
Per

"srosetti" skrev i meddelelsen
...
What I'm looking to do is populate one field with data when another
equals certain variables.

For instance:
Column B has the variable data and Column BA has the destination or
place I want to populate the data.

If Column B reads Widgets then I want Column BA to read parts, widgets
If Column B reads Small widgets then I want Column BA to read parts,
small widgets

I have quite a few variables for Column B, but I know what the output
should be in BA. Problem is
I have over 1200 data entries and I want some help to populate these
entries.

How do I go about doing this??


Thanks

Not sure what to call this
 

On Oct 27, 1:27*pm, "Per Jessen" wrote:
Hi

Insert this in BA2 and copy it down as required:

="Parts, " & B2

Hopes this helps.
...
Per

"srosetti" skrev i ...

What I'm looking to do is populate one field with data when another
equals certain variables.

For instance:
Column B has the variable data and Column BA has the destination or
place I want to populate the data.

If Column B reads Widgets then I want Column BA to read parts, widgets
If Column B reads Small widgets then I want Column BA to read parts,
small widgets

I have quite a few variables for Column B, but I know what the output
should be in BA. *Problem is
I have over 1200 data entries and I want some help to populate these
entries.

How do I go about doing this??

Thanks



That would work, but I guess I didn't give enough information. The
Value in Column B won't always equal that in BA.

BA could read Parts, #variable or accssries, #variable

both entries for #Variable could be many different things as I have
probably 50-60 different categories that will fill that variable.

Not sure what to call this
 

Create a two-column lookup table on a new sheet (Variable, Destination) and
populate that with your pairs of values
Eg:
Widgets parts, widgets
Small widgets parts, small widgets
etc.

use a vlookup formula in col BA

Eg;

=VLOOKUP(B7,Sheet2!B$2:D$14,2,FALSE)

Tim



"srosetti" wrote in message
...
What I'm looking to do is populate one field with data when another
equals certain variables.

For instance:
Column B has the variable data and Column BA has the destination or
place I want to populate the data.

If Column B reads Widgets then I want Column BA to read parts, widgets
If Column B reads Small widgets then I want Column BA to read parts,
small widgets

I have quite a few variables for Column B, but I know what the output
should be in BA. Problem is
I have over 1200 data entries and I want some help to populate these
entries.

How do I go about doing this??


Thanks