lookup function to ignore blanks

[sashabaz]

I have 2 worksheets. List and Main. List takes data from other worksheets
to calculate totals for various diciplines. there are 7 disciplines each
with the same three rating subjects. Each of these discipline ratings are
set to a company in the list.

E.G.
Company Name Art
Quality Cost Value
Company A Good Average Poor

What I want to do is to move the info to another sheet, changing the format
and only showing the disciplines/compnaies that have been rated.

So, If Company A has been rated for Art and Audio but not Hats the following
is shown in the"Main" sheet:

Company Name Discipline Quality Cost Value
Company A Art Good Good
Good
Company A Audio Poor Poor
Poor

Obviously there are more companies and disciplines available. the list of
companies and disciplines can be updated thererfore I cannot have a fixed
list to check on.

Thanks

 

[Pete_UK]

Did you try the solution I suggested to your other (similar) post
yesterday? Can you not adapt the ideas from that?

Pete