antoka05
Forum Guru

i am trying to display the result using nested vlookup and if statement. but i am not getting the result. please help me to do this.

Here is my formula: IF(VLOOKUP(G5,M3:V17,2,0)=(HLOOKUP(G3,M3:V17,ROW(),0)), (VLOOKUP(G5,M3:V17,2,0)=(HLOOKUP(G3,M3:V17,ROW(),0)), 1))

where i underlined, i need to display the result of comparision. which i am not getting. Please help me how to get that

Hi, I need a help from you.

Thank you Antonio. The macro is awesome. Can't wait to use it at work. Cheers

Hi antoka ,
I am new to excel programming , i would be very greatful if you could help me out in some areas . Looking forward to your reply . Thanx in advance

Hi Antonio.
If you have a chance could you look into of the last post on http://www.excelforum.com/excel-prog...licates-2.html. I'm trying to do another macro and could use little bit of your expertize.

Cheers
Rain

Hi Antonio
If you have some free time can you look my last post in this thread http://www.excelforum.com/excel-prog...uplicates.html I learned from your code and and implemented all the knowledge to sort out another report but I need slight help with the last obstacle. I would really appreciate any help you could offer.

Cheers
Rain