Horizontal and Vertical lookup
Hello Lisa,
Am Mon, 30 Apr 2012 13:45:03 +0000 schrieb Lisa M:
Example
A B C D
Date From To # Miles
Burr Holland Hill 5
try:
=INDEX(Sheet2!C1:C100,MATCH(B2&C2,Sheet2!A1:A100&S heet2!B1:B100,0))
Array formula to enter with CTRL+Shift+Enter
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|