Formula required - Show something IF something else is there...

[IoHeFy]

Hi!

OK - Coloumn B is full of different regions, let's call them Alpha, Beta,
Delta, Gamma. Each region is assigned to someone specific, e.g. Alpha = Anne
Other, Beta = Joe Bloggs, Delta = Whatzis Name, Gamma = Someone Else. I need
coloumn C to automatically fill in all of its rows with the correct persons
name depending on which region is in the corresponding row from coloumn B.

Is there a formula I can use for this? Hope it all made sense!

Cheers!

 

[Don Guillett]

Have a look in the help index for VLOOKUP for a formula solution or use a
select case macro

 

[Kevin B]

The following formula has the sales persons name in a1, with the region
VLOOKUP formula in column B. The lookup table is in D1:E4

D E
Alpha Louie
Beta Vito
Gamma Angela
Pi Victoria

The formula is as follow:

=VLOOKUP(A1,$D$1:$E$4,2)

Where A1 is the value to match, $D$1:$E$4 is the location of the table
(using absolute references, and 2 is the column to extract the matching value
from.

 

[Carlo]

Hi IoHeFy

it depends were you have stored the linking information,
is there a second sheet, with all the infos?

Try "VLOOKUP" should work fine.

Cheers

Carlo

 

[Toppers]

Table of regions and names in say columns A & B of sheet2 then in column C,
starting row 2 (assuming row 1 is a header)

=VLOOKUP(B2,Sheet2!A:B,2,0) and copy down

To allow for errors:

=IF(ISNA(VLOOKUP(B2,Sheet2!A:B,2,0)),"",VLOOKUP(B2,Sheet2!A:B,2,0))

HTH