After you get that table built, you can use the =vlookup() in the other post.

=if(a1="","",vlookup(a1,sheet2!a:b,2,false))



badgrandntl wrote:
>
> So what formula can I do to match this stuff up, I listed the correct
> cells in my above post, Dave I will take your advice and move the stuff
> it make more sense that way, but I just need it so when I selec the
> product the price comes up.
>
> Thanks Scott
>
> --
> badgrandntl
> ------------------------------------------------------------------------
> badgrandntl's Profile: http://www.excelforum.com/member.php...o&userid=31035
> View this thread: http://www.excelforum.com/showthread...hreadid=507020

--

Dave Peterson