I don't want to just view a list and I don't want to have to filter
every time I need an answer.

I have over a thousand cells to fill in
For example to fill in column Z, I need to seach in the table for the
data in constant cell "$Z$1" for OP1, OP2, etc.
then narrow down the search by the data in column G
then narrow down the search by the data in coumn K

then in the single line of data I am down to, find the size in the
column that corresponds to column K in my original spreadsheet.


--
carstowal
------------------------------------------------------------------------
carstowal's Profile: http://www.excelforum.com/member.php...o&userid=37476
View this thread: http://www.excelforum.com/showthread...hreadid=571375