Indexing/Referencing
 

I have a 3 colums of data with 180 entries in each that remain at a constant
throughout ... such as ID No / Surname / Foremane

I have many other sheets referencig this information and am looking for a
way that if a cell contains the data equalt to A1 then I can have excel fill
in the deatls B1,C1 as appropriate ... Ie if ID No is entered then excel will
populate adjacent cells ??

Many thanks for any suggestion

Alan

Hi
use VLOOKUP. e.g. try in B1 and C1
=IF(A1<"",VLOOKUP(A1,'data sheet'!$A$1:$C$200,2,0),"")
and
=IF(A1<"",VLOOKUP(A1,'data sheet'!$A$1:$C$200,3,0),"")

--
Regards
Frank Kabel
Frankfurt, Germany


Alan wrote:
I have a 3 colums of data with 180 entries in each that remain at a
constant throughout ... such as ID No / Surname / Foremane

I have many other sheets referencig this information and am looking
for a way that if a cell contains the data equalt to A1 then I can
have excel fill in the deatls B1,C1 as appropriate ... Ie if ID No is
entered then excel will populate adjacent cells ??

Many thanks for any suggestion

Alan