Formulas nested in vlookup

I do not know if this is possible but I would like to nest a formula in a vlookup that would return information from the row where the lookup is returned.

I have two worksheets one with detail data the other with summary data. I am looking up a value on the detail to the summary to give an explination. Within this explination I would like to reference a volume that is found in the same row on the detail page.

For Example


Sample Detail Table

	A	B	C	D	E
1	Type	Name	Product	Volume	Explination
2	Check	Abc	1	50
3	Wire	Def	8	34
4	Check	Ghi	9	57
5	Check	Jkl	8	702
6	Wire	Mno	5	65
7	Wire	Pqr	6	40
8	Wire	Stu	7	482
9	Check	Vwx	3	45
10	Check	Yz	8	86

Sample Summary Table

	A	B
1	Type	Explination
2	Check	This customer is using a checking account with monthly volume of (volume from row).
3	Wire	This customer is performing wire transfers out of their account with a monthly volume of (volume from row)

I would like to use a formual in Column E of the Detail table

Vlookup(A2,Summary!$A$1:$B$3,2,false)

The issue I am having is how I can referece column D from detail in the return.

Thank you for any help.

DBY,

Thank you for the response.

Unfortunately this solution will not work.

I simplified the tables in my example and the "volume" information can be sourced from 1 of 5 columns depending on the explination for the product.

I was hoping to use a concatenation in the explination cell with and index formula but cannot figure out how to make the range of the index formula = current row.

Hopefully this provides a little more color around my inquery.

Best,
Kevin

FDibbins,

Thank you for the suggestion.

I have attached a file with the two worksheets and some sample data.

I would like the lookup to be able to reference the specific "Credit Grade, Volume, Count, proccessed" on a given row in the detail table.

Thank you,
Kevin

Hello
The only way I could think to do this would be to use a series of nested Substiute functions with Vlookup. For example to replace: 'credit grade'; 'count'; 'Volume'; and 'processed' as stated, then:

Please Login or Register  to view this content.

Copied down column I on the 'Detail Table'. It appears to work with your sample file but I'm not sure how robust this method will be when and if you add more 'Rationale' to your Summary table.

*Note in your Summary table there's a spelling error with 'credit gade' and 'processed' is missing a closing("). These need to be corrected for the above formula to work.

Hope its of some use.
DBY