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!