On Aug 8, 12:36 pm, geo chevko
wrote:
i need to enter 2 paramters to find a product.

para.1 para.2 answer
2" pipe $2

pipe is a vertical lookup & 2" is horizontal. both are in a different
worksheet

How do they inter-relate if they are in different sheets? Where does
the $2 answer actually come from?