Catalog # lookup

Originally Posted by bebo021999

Try in D21:

=VLOOKUP(A21,'catalog #'!$A$2:$C$4,3,0)

In C21:

=HLOOKUP(B21,$A$2:$S$18,LEFT(D21,1)+LOOKUP(100,SEARCH({"small","medium","large"},D21),{0,1,2})*6+1,0)*B21

Thank you, it's working on the small sheet now I have to try it on the real thing.
I'll keep you posted.