It's late here and I'm having difficulty visualising what you have, so
it would be a good idea to post an example of the layout of your
table. Give details, also, of what columns/cells you are using.

However, I think you can do what you want by using an INDEX/MATCH
combination.

Hope this helps.

Pete

On Jan 17, 1:32*am, stogie wrote:
Hey group, I am an FNG to the group but have experience with Excel,
but I have hit a new snag. I am using Office
2007. I am familiar with Lookup, less so with H/VLookup, but I have
what seems to be a reverse operation. At work
we have a number of tables for a variety data and we are working on a
"universal" spreadsheet, so current data has
to stay in the same format.

This said, the table I am working with now has two headers. The one
down the side lists wire gauge. The one
across the top lists conduit size, as is separated vertically from the
data field I am working with. This data field
contains quantity of wires per the size header that can fit into a
conduit size noted per top header. I have the wire gauge as a variable
and the wire quantity as a constant. I need to find the corresponding
row, find a cell equal to or
greater than the constant, and return the column header. Can this be
done?

Thanks in advance,
Stogie