Hello from Steved

I've a summary sheet called Starttrip, In Col A
I've got names "Peter", "Stan", "Maranda", "Stewart", "Carol".

I've got sheets named "Peter", "Stan", "Maranda", "Stewart", "Carol".

=IF(Summary!A6="Peter", ROW(),"") This is in Sheet named "Peter"

What is required in the formula below to reconize "Peter" please, or what is
required .

=IF(ISNUMBER(SMALL(IF($B$2:$B$106="","",ROW($B$2:$ B$106)),ROW(1:1))),INDIRECT("Starttrip!"&CHAR(COLU MN()+64)&SMALL(IF($B$2:$B$106="","",ROW($B$2:$B$10 6)),ROW(1:1))),"")

Thankyou.