MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Multiple lookup


Posted by Sleiman El-Khoury on June 23, 2001 8:31 AM

how can I build a formula that can lookup for 2 combined crieteria in one range like:
=vlookup((AND(A5,A6)),C10:D20,2,false)

can anybody help me?


Posted by Aladin Akyurek on June 23, 2001 9:27 AM

Sleiman

It would help immensely, if you could post the data in C10:D20. In order to do so, select an unused cell, type =, select C10:D20, and hit CONTROL+SHIFT+ENTER at the same time. Now go the formula bar, select the formula {=C10:D20} and hit F9. You'll see your values between braces. Copy the lot and post it in the follow up along with the values that you have in A5 and in A6.

Aladin