I am trying to creat a price sheet such that when any part number is shown
it is assigned the proper price.

ie Part No. Price
XY $5.50
Ab $2.20

I've tried this with the if function but always come up with #Value!