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
|