vlookup finding non blank value

[greg.begin]

I have a list of Customers in column B. In column I i have an alternate name. the alternate name once given is always the same. The customer's name can appear multiple times becuase of different dates they visit, but the alternate name might appear on the 6th visit and that is all. what formula can i write to find the alternate name regardless of when the customer visited.

 

[Debraj]

Hi Greg,


Can you please try the below for me...

=IFERROR(INDEX($I$2:$I$23,MATCH(1,($B$2:$B$23=B2)*NOT(ISBLANK($I$2:$I$23)),0)),"")

https://dl.dropbox.com/u/78831150/Excel/vlookup%20finding%20non%20blank%20value%20%28Greg%29.xlsx


Regards,

Deb

 

[greg.begin]

Wow, had to change "=B2" to ="A2", but it works great. also, had to make it an array formula.

Thank you so very much.


=IFERROR(INDEX($I$2:$I$23,MATCH(1,($B$2:$B$23=A2)*NOT(ISBLANK($I$2:$I$23)),0)),"")

 

[Debraj]

Hi Greg..


Thanks for your kind words..


Happy to help..


Regards,

=DEC2HEX(3563)