Hi, I was wondering if someone could help me with a data retrieval/lookup
issue I am having.

I am setting up a Workbook that tracks royalty reports for 3 dozen licensees
we work with. I am outputting data from our accounting system to a worksheet
and I want to look up the sales revenue for each licensee and copy/retrieve
that data into the template. The problem is, there are multiple licensees
with multiple product types.

I have tried doing this with a nested vlookup like this:

=VLOOKUP(A13,QBData_Feb!A:I,VLOOKUP(C4,QBData_Feb! B:I,8,FALSE),FALSE)

I can see in the formula editor where the value I want is being identified
next to the Col_index_num line, but this is not being dumped to the cell as
my data.

Perhaps someone can offer an alternative?

My data looks like this:

DataSheet: QBData_Feb
DataRange: QBData_Feb!A:I
Lookup/Template Sheet: Royalty Report (Feb07)
Lookup Criteria1: various licensees in column A
Lookup Criteria2: various product types in row 4

Basically, I need this to look up each licensee by product, see if they have
any royalties due to them in the outputted datasheet, and then transfer that
data into the corresponding cell on the template.

Any thoughts are appreciated. Thanks!