Hi, I'm new to this forum.
I am trying to create Part and Price data base, where entering in a particular part number and quantity pulls up the serial number and price depending on quantity ordered. I was able to do a VLOOK UP [formula used is "=VLOOKUP(D2,$A$7:$B$61,2,FALSE)"] to find the serial numbers, however the part I'm struggling with is how to pull up the price. The pricing would be from columns L through T, with headers in row 7. Can anyone help please? Not sure how to upload an image of my spreadsheet for a better visual.
I am trying to create Part and Price data base, where entering in a particular part number and quantity pulls up the serial number and price depending on quantity ordered. I was able to do a VLOOK UP [formula used is "=VLOOKUP(D2,$A$7:$B$61,2,FALSE)"] to find the serial numbers, however the part I'm struggling with is how to pull up the price. The pricing would be from columns L through T, with headers in row 7. Can anyone help please? Not sure how to upload an image of my spreadsheet for a better visual.