A lookup function can get data from any number of columns - it all
depends on how wide you set your table. Give us a few more details,
including a copy of what you have tried to use, then we might have a
better chance to help you.

Pete

On Oct 9, 8:28 pm, TheWiz? wrote:
I am working on a MAC in excel and need to create reports for my client that
will generate from excel file that he currently has. I tried to use the look
up function the problem is that this function will only search the first two
columns. I need to know a formulation that will poplulate a cell based on a
letter or number value to form addtional reporting for this client. For
example a 8 column sheet with 30 rows of repeated info will popluate a 3 row
to column shorter reports to be broken down by location. I know this sounds
confussing but some one help me. Please!