find the column

=Match("Price",A1:Z1,0)

once you have the column then

Use a number larger than any in the column (assume you are looking at
numbers)
match(999999999999,F1:F500,1)

so

Putting it all together:

=OFFSET($A$1,MATCH(999999,OFFSET($A$1,1,MATCH("Pri ce",$B$1:$Z$1),500,1),1),M
ATCH("Price",$B$1:$Z$1))

--
Regards,
Tom Ogilvy


"Les Stout" wrote in message
...
Hi all, is it possible to look up a number on the top of the sheet,
let's say a1, b1, c1,d1,etc.. and get the value in the last used cell of
the column or must one copy and past them left to right ??

thanks in advance,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***