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