Hi, I need to add different amounts to a column of prices based on a column of zone numbers.
I don't know if that makes sense but here is an example test.xlsx
thanks
Longshot9921
Hi, I need to add different amounts to a column of prices based on a column of zone numbers.
I don't know if that makes sense but here is an example test.xlsx
thanks
Longshot9921
Try this in C2 and copy down:
=B3+VLOOKUP(A3,G$10:H$16,2,FALSE)
this would work though it isn't very elegant.
=IF($G$10=A2,B2+$H$10,IF($G$11=A2,B2+$H$11,IF($G$12=A2,B2+$H$12,IF($G$13=A2,B2+$H$13,IF($G$14=A2,B2+$H$14,IF($G$15=A2,B2+$H$15,B2+$H$16))))))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
This is another way to match up the data and make the calculation.
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks