Hello All,

Let me try to make a long story short. I have created a spreadsheet
that does fantastic things, however I want to be able to reference a
price from an ID Number after entering the ID into a cell on a
different sheet. This way I don't have to stare at a piece of paper to
figure out the price, which wastes man-time. The catch is there are a
lot of ID numbers to "Search". The price/ID info are on a separate
sheet. I'm thinking 'SumProduct', but do I have to create a function
in VBA to "search" them or is there an easier way?

If you can supply the logic, I can create the code. Or visa-versa. I
have tried without avail ":(

if that makes sense, Thanks!
If not, thanks for wasting your time!

-Titus.