All2Cheesy
Board Regular
- Joined
- Mar 4, 2015
- Messages
- 127
Hi all,
I'mn probably going to do a terrible job at explaining this, but I need to write a formula to identify which city is sending freight to what postcode. Currently I have a formula(below) which can do this, however, I run into trouble when there are two different cities sending out to the same postcode. The formula I'm using will only list the first city. Is there anyway to have my formula look up the next value once the first value has already been found? Your help is greatly appreciated.
To P/C From city
6017 Melb
6027 Melb
4110 Melb
2680 Melb
2680 Sydn
6104 Sydn
4151 Sydn
4558 Sydn
I'mn probably going to do a terrible job at explaining this, but I need to write a formula to identify which city is sending freight to what postcode. Currently I have a formula(below) which can do this, however, I run into trouble when there are two different cities sending out to the same postcode. The formula I'm using will only list the first city. Is there anyway to have my formula look up the next value once the first value has already been found? Your help is greatly appreciated.
Code:
=IFERROR(VLOOKUP(A1,'Postcodes'!$F$23:$H$1048576,3,FALSE),"")
To P/C From city
6017 Melb
6027 Melb
4110 Melb
2680 Melb
2680 Sydn
6104 Sydn
4151 Sydn
4558 Sydn