Man I hope I explain this correctly...
I use Excel for a purchase order log. Most materials have a set cost & I have a tab in my log with all materials and use VLOOKUP to input the cost of per line item entry based on the item ordered. However, I have 2 products whose prices vary depending on the location of delivery (job site) and would like to know how to write a formula to look for & input job-specific pricing when a) a certain material is selected and b) a certain job name/number is selected but I would need it to also return the standard cost for non job-specific products as it does now. I have NO CLUE how to go about this.
So I need it to look at the material ordered and if its A or B, look for job-specific pricing but if its anything other than A or B, I need it to look for standard pricing like it does now w/ the basic VLOOKUP to my current cost tab.
Thanks in advance for any advice!
I use Excel for a purchase order log. Most materials have a set cost & I have a tab in my log with all materials and use VLOOKUP to input the cost of per line item entry based on the item ordered. However, I have 2 products whose prices vary depending on the location of delivery (job site) and would like to know how to write a formula to look for & input job-specific pricing when a) a certain material is selected and b) a certain job name/number is selected but I would need it to also return the standard cost for non job-specific products as it does now. I have NO CLUE how to go about this.
So I need it to look at the material ordered and if its A or B, look for job-specific pricing but if its anything other than A or B, I need it to look for standard pricing like it does now w/ the basic VLOOKUP to my current cost tab.
Thanks in advance for any advice!