allinsca,

Take a look at the VLOOKUP function.

HTH,
Bernie
MS Excel MVP


"allinsca" wrote in message
...
Hi,

I have a worksheet with rows of information and varying coloumn headings. I
am trying to find a way to be able to grab information from a single row and
pull it onto a separate worksheet. (I want to be able to type in a
respective # on the separate worksheet and the corresponding info show up.)

I am not sure what this is called but I know it is common. Any help would
be fantastic!
--
Thanks!