And/ Or Function for calculating shipping costs

Can anybody help me with the attached formula im trying to work out to calculate shipping or air freight costs to two or more countries

Thanks in advance

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

Once you have changed your title, than please do as asked and provide a manually calculated result in the yellow box to show what you want to achieve.

b11=INDEX($B$3:$E$4,MATCH("*"&LEFT($B$10,SEARCH(" ",$B$10&" ")-1),$A$3:$A$4,0),MATCH("*"&$B$8,$B$1:$E$1,0))

Please Login or Register  to view this content.

Sorry Ali, while modifying my post after watching your post, you modified my post

I'll reinstate it when the OP has complied with the request.

You were asked to provide, manually, your expected outcome in the yellow cell (B11):

Excel 2016 (Windows) 32 bit

	B	C
11		< formula please

Sheet: Sheet1

I suggest you do not take issue with members who ask you for more detail - you are unlikely to have many willing helpers with that attitude.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.