@googlegroups.com
Subject: Re: $$Excel-Macros$$ pls help with matching postal codes
actually, if there is no exact value, it should give me next smallest or
largest value- which ever is closest. i tried vlook up with true- but a lot of
cases, it is not the closest. pls check out after u use vlookup true
actually, if there is no exact value, it should give me next smallest or
largest value- which ever is closest. i tried vlook up with true- but a
lot of cases, it is not the closest. pls check out after u use vlookup
true. It is not always the closest
Best case scenario is exact and then next
Hi Sara,
You can also you use..
*=IFERROR(LOOKUP(H2,Sheet1!$C$1:$C$72),"")*
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Mon, May 7, 2012 at 9:39 AM, Sara Lee wrote:
>
>
> --
>
> *col i *in Sheet 2 needs to be filled up
>
> by looking
