I gotta vlookup table and on tha other worksheets people enter the info from
dropdown boxes. I need to show the books sold and the average of looks at it
after being chosen to be listed as a summary.

A B C
red book $15 x
Blue book $10 x
red book $20 w

So if a "red book" "$15", a "blue book" "$10" and a "red book" "$20" was
sold, and I want to list red book or W books, how can I display this summary
info?

It should look something like this so i can use the figures for sums and
division.
Red Book | 2 | $35
Blue book | 1 | $10
and/or
Red Book | 1 | $20 w - based on W.

Now need a result.
eg. 2 red books divide 43 people who looked at it gives me the result I need.

That's it!