I have a price list of over 3600 items.

Item Numbers located A3-A3607 and costs are C3-C3607.

I would like to build a "bid tool" next to the price list where I can enter any part number in A3-A3600 into E3-E40 and it would automatically pull pricing for each item into F3-F40. Allowing me to create quotes for my customers without having to copy and paste from A3-A3607 and C3-C3607.

I am thinking I would type in part numbers into E3-E40 but I need a formula in F3-F40 that would pull the corresponding cost.