Shorten the formula..

[VBABEGINER]

Dear All, Can you please help me in reduce the below formula please.. I appropriate you in advance to look my query..

=IFERROR(VLOOKUP(CONCATENATE($C11,$D11,$E11,$F11,$G11,$H11),WKL_Pivot!$BG:$BO,8,0)/VLOOKUP(CONCATENATE($C11,$D11,$E11,$F11,$G11,$H11),WKL_Pivot!$BG:$BO,9,0),"-")

 

[steve the fish]

Aside from perhaps doing the concatenation in a helper cell it already looks short to me.

 

[VBABEGINER]

Thanks, Steve. For your reply first.
Yes, it is short formula...But since i was board member of Mrexcel, I see lot magical formula's expert's (like u also) know and it is exist. And I am still in learning part, and hence always take help from this site, which really works like bread n butter solution for me..

Hence, if you know anything much better...then please share..

Aside from perhaps doing the concatenation in a helper cell it already looks short to me.