Cutter
Forum Guru

Hi Cutter thanks for the help re: Recurring values.

any ideas on value a1 value 1 /75*3 rounding off at 0.40 instead of 0.39 the =TRUNC(TRUNC((I19/30),6)*6,2) worked a treat just no idea how to reconfigure it for the above.

Hi Cutter can you Kindly help me with thread "Need to show summary result for each country seperatly in one sheet"

well, sir, haven't we all (learnt from NBVC)? still takes nothing away from your cleverness...

Thank you for your help!

You definitely Cut our issues from the roots.. Thanks a lot... the "Skype click to call' w.r.t. Clipboard issue was a rocker.... Thanks a lot for your help...

Cutter, I never could have accomplished that varying "named range" into the existing index/match formula without your help! you rock!

Another big thanks for going out of your way for a new forum user! Hope all is well in the North and give your dog a treat for me!

Dear Cutter,

Please check the issue with the title" Re: Match data from two sheets" created on 21 May. for which you asked for some sample file, which have been duly uploaded on 22 May
.
Please help
.
USMANIV

Thanks for your quick response. You made it look very easy. Thanks again!

Cutter,
I am new to VLOOKUP....but, I figured it out and have it working....however, when the formula references another cell that is empty I get the #N/A error. Can you help? Thanks in advance.