Validation Boxes and dependant cells

[Bostick73]

Here is the problem...

I have a list on sheet 2: THis is not the complete list, the actual i
400 names long. the range is called "Names"
A B
Derek | 575
Bob | 500
Jonny| 200
Doug | 300


On sheet 1 i have a validation box in row A that applies to the rang
of "names" in sheet two
I would like to have the number that coresponds with the name come u
in cell B when the validation box is filled in A.

Thanks,

Dere

 

[JulieD]

Hi

use can use VLOOKUP for this
in cell B on sheet 1
type
=VLOOKUP(A1,Names,2,0)
where A1 is the location of your validation box

to supress the #NA error that occurs when A1 is empty place it in an IF
statement
=IF(ISNA(VLOOKUP(A1,Names,2,0)),"",VLOOKUP(A1,Names,2,0))

Cheers
JulieD

 

[Frank Kabel]

Hi
have a look at VLOOKUP for this

 

[icestationzbra]

try the VLOOKUP function.

=VLOOKUP(A1,Sheet2!A1:B4,2,FALSE)

say Sheet1 A1 has the value 'Bob' from your example, place this formula
in the cell Sheet1 B1. it will result in 500.

 

[Bostick73]

I get An #REF error, when i place any of the above solutions in B1

thanks- Dere

 

[Bostick73]

THanks i have it now, i was inputing it wrong!

Thanks for your help!

-Dere