Excel Help on Lookup should give you some ideas.

What don't you understand from Help on that subject?

Note also the VLOOKUP and HLOOKUP functions. One of them may be better suited
to your needs.


Gord Dibben Excel MVP


On Thu, 6 Oct 2005 13:51:06 -0700, "Shail Patel" <Shail
wrote: