Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|