Hi,
I am new to this type of forum.
I have a list of postcodes with ranges (eg BH1-25 & BH26-50) each of these 2 different areas has a different postage cost.
I want to find the postage cost from a post code ie comparing the first letters to a list and then doing some sort of greater than and less than from maybe 2 other lists.
ab 1 25 CALL
ab 26 99 £91.43
AL 1 99 £41.12
b 1 99 £37.25
ba 1 99 £41.12
bb 1 99 £41.12
bd 1 99 £41.12
bh 1 10 £42.41
bh 11 23 £53.38
bh 24 99 £47.80
For example from above for BH15 returning £53.38. I have taken and split the letters from the numbers so have BH in a cell and 15 in a cell.
Any ideas / help - Must be some sort of array of lookup and sumif ???
Thanks
Steve
Bookmarks