
31st May 2006, 12:40 PM
|
|
Suspended
|
|
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
|
|
Bit of tinkering and reading got it to work like this.
=LOOKUP(Sheet2!A1,Sheet1!A1:Sheet1!A3,2)...Yours
=LOOKUP(A1,'Race Records'!A$1:A$320,'Race Records'!B$1:B$320)...Mine
Thanks for the legup La Mer.
Maybe enough with the Programs Chrome Prince.
Ain't worked Excel out yet...Frightened to try learning another one.
|