The Cyclone Edition
Brought to you by Ntw Productions
Pages
Home
Tools & Resources
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment