VLOOKUP with 2 Criteria

**nj8988** · 01-25-2013, 02:58 PM

I am trying to find the value of CSV! Column AE,

if CSV! Column AC matches Sheet1! Cell A2 and CSV! Column AD matches Sheet1! Cell A3.

The value should go into Sheet1! F3. You can see the formula I tried from someone with a similar question, but am getting an error in return.

Any help would be appreciated.

Thanks,

Nick

**oeldere** · 01-25-2013, 03:06 PM

Maybe (probably) with an pivot table.

See the attached file.

This is just an example how you can do it.

There are other options within a pivot table.

**FDibbins** · 01-25-2013, 03:14 PM

This will work, but you have no match of A2 and E3 in CSV

Add a helper column at the end in the data in CSV and use this, copied down...
=AC39&AD39

Then use this to find the info
=INDEX(CSV!$AE$1:$CB$78,MATCH(Sheet1!A2&Sheet1!E3,CSV!$BZ$1:$BZ$78,0),1)

However, the way you have your data laid out on sheet1 in column A is going to make things difficult. It would be better if you could have a column for call list, and then 2 more columns, 1 for start date and another for end date