Lookup with 2 criteria

[daveyy]

Hi Guys,

Thanks for taking the time to read this thread. Hopefully you will be able to offer some assistance.

I have attached a workbook with 2 worksheets Refund & Factor. In brief I wish to work out the refund on a ticket. To do this I have entered the start date & surrender date. In C29 I have a formula that gives the datediff in months & days. I then have some VBA that extracts the numbers and enters them into D29 & E29.

I now need a formula to look at the factor sheet and find the intersection between 3 (months) & 19 (days) which is 13.96 and copy this to B36 on the refund sheet.

Any help offered will be greatly appreciated.

[Domenic]

Try...

=INDEX(Factor!$B$3:$L$33,MATCH(Refund!E29,Factor!$A$3:$A$33,0),MATCH(Refund!D29,Factor!$B$2:$L$2,0))

[daveyy]

Many thanks Domenic.

If I hadn't been so focused on Lookups, I should have given Index & Match a go. Thanks so much for your help, this works a treat.

Dave