Indexing/Referencing

[Alan]

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

 

[Frank Kabel]

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),"")