lookup using multiple conditions

[bcc]

I am wanting to do a vlookup style return of data but instead of just matching the one condition, i want it to match 2 conditions. For example i have data of:

• 111909 400.00 111909 2,000.00 n/a
  123432 400.00 123432 400.00 400.00
  123456 540.00 111909 400.00 400.00
  134567 540.00 134567 540.00 540.00

So what i want to do in column E is use the value in Row 1 Column C and find a match in column A and also use Row 1 column D to find a match in column B and where both of these match on the same row in columns A & B, return the value from column B. I want to be able to copy this formula down all rows in Column E so that each unique row in Column C & D looks for a corresponmding matching row somewhere in column A and B. The data i have got in the E column above is what the formula should return if working correctly.

I have tried various forms of index and match but not quite sure if i'm on the right track.


Thanks

BCC

 

[Brian from Maui]

See if this helps,

http://www.mrexcel.com/board2/viewtopic.php?t=51467