View Single Post
  #5   Report Post  
Mazzaropi Mazzaropi is offline
Senior Member
 
Location: Belo Horizonte, Brazil
Posts: 170
Thumbs up

Quote:
Originally Posted by Iyanna View Post
Thank you for your reply. But this formula is still resulting in an amount being shown in Column C, even when that account number is present on the list of accounts to exclude.
-------------------------------------------------------------------------

Dear Iyanna, Good Afternoon.

"...But this formula is still resulting in an amount being shown in Column C, even when that account number is present on the list of accounts to exclude..."

It´s sounds so strange.

Are you sure that you typed correctly the formulas?

The EXACT example is saved here : http://www.4shared.com/document/A6YQ...r_VLOOKUP.html

Please, take a look at it.

If you need help to implement this formula to your worksheet, save it at a free site, www.4shared.com, and put the link here.

I can and I want help you to solve this problem.
__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil