Item: Value in (DC#1): Value in (DC#2):
510 lookupformula#1 lookupformula#2
This information is on tab A of the worksheet.
Item: DC Value: Type: Amount:
510 DC1 Gross 10
510 DC1 Change -5
510 DC1 Net 5
510 DC2 Gross 15
510 DC2 Change -5
510 DC2 Net 10
This is the information on tab B of the worksheet.
What I am wanting in lookupformula#1 is a formula that will evalute tab b for... Item 510, DC1, Net. Thus, the value of lookupformula#1 would be 5. Further, the value of lookupformula#2 would be 10.
I hope that this is enough information and that I have made myself clear. This is my first time on the forum and after many hours of googling and index matching with no success this is my last hope. Thanks everyone!