Validation Boxes and dependant cells

B

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
 
J

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
 
I

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.
 
Top