Please see attached,
I need to include a VLookup function to calculate the amount of the delivery charge on each sale according to the percentage given in the Delivery charge table.
I know Vlookup basics but adding calculations to the formula is beyond me, help?!
Hi there,
Sounds like something I could do if I could actually see it. Your attachment doesn't open for me and says it's an image. Example workbook is usually best, so people can see exactly what you mean. I think that's why you haven't had any replies yet.
Can you please upload a better example and i'll try and do it for you?
Thankyou for your reply, Ill upload the workbook for you but I am working on a Mac (slightly embarrasing to admit being a microsoft forum).
Like this if I understand you correctly....
Formula:
Please Login or Register to view this content.
Please see attached, is this what you mean?
............................
Last edited by D.Lovell; 05-26-2015 at 07:10 PM.
I have filled in the other boxes based on what it looks like you are trying to do, hope it helps
Last edited by D.Lovell; 05-26-2015 at 07:12 PM.
I cant thank you more D.Lovell! Saved my day.
Glad to be of service, please mark the tread as solved if your question has been satisfied
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks