Ads

Tuesday, March 24, 2009

Excel at Excel

Here is my two variable lookup formula with variable lookup length:

{=INDEX(INDIRECT("L2V!C$4:C"&Configs!$I$16),
MATCH(Configs!$T2&Configs!$U2,
INDIRECT("L2V!$A$4:A"&Configs!$I$16)
&INDIRECT("L2V!$B$4:B"&Configs!$I$16),0))}

No comments: