Forum Discussion
Solved
Vlookup nesting
Hi, I have a list of postcodes form participants that I need to assign a "remoteness" area to. They include Major cities of Australia, Inner regional, Outer regional, remote and Very remote. T...
kmat3540 Sort your data by percentage and use "FALSE" as the last argument in the VLOOKUP function. Then it will work.
File attached.
kmat3540 Sort your data by percentage and use "FALSE" as the last argument in the VLOOKUP function. Then it will work.
File attached.
Thanks so much Riny_van_Eekelen .
It worked. The solution was simpler that I thought.
Cheers 🙂
Karen