Selecting rows from various sheets

S

shav

Thanks for the reply Frank, but unfortunately it's a bit over my head.
Something simpler would be better. I've managed to create a column that
has unique values of all the identifiers. So now all I need to do, is
compare the unique identifier with the other sheets and extract the
data from the other columns on each sheet. Cheers
Shav
 
F

Frank Kabel

Hi
what is so difficult with VLOOKUP?. Use something like
=VLOOKUP(A1,'other_sheet'!A1:B100,2,0)
 
Top