Hello,
I need help with "vlookup" and "If" formula together under "Deal Type ID" below. I need to assign a value to " Wholesale" if there is "D" in "deal type" column "A" and the vlookup Lender Name to look up either " Outside Finance" or "Cash"
First Sheet:
[TABLE="width: 390"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Deal Type
[/TD]
[TD]Lender Name[/TD]
[TD] Deal Type ID
[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]Net Direct Auto Sales[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]Net Direct Auto Sales
[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]WELLS FARGO DEALER SERVICES[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]WELLS FARGO DEALER SERVICES
[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]WELLS FARGO DEALER SERVICES
[/TD]
[/TR]
</tbody>[/TABLE]
Second worksheet:
[TABLE="width: 442"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Lender Name
[/TD]
[TD]Deal Type
[/TD]
[/TR]
[TR]
[TD]A+ FEDERAL CREDIT UNION[/TD]
[TD]Outside Finance[/TD]
[/TR]
[TR]
[TD]AAFES FEDERAL CREDIT UNION[/TD]
[TD]Outside Finance[/TD]
[/TR]
[TR]
[TD]ABILENE TEACHERS FCU[/TD]
[TD]Outside Finance[/TD]
[/TR]
</tbody>[/TABLE]
I need help with "vlookup" and "If" formula together under "Deal Type ID" below. I need to assign a value to " Wholesale" if there is "D" in "deal type" column "A" and the vlookup Lender Name to look up either " Outside Finance" or "Cash"
First Sheet:
[TABLE="width: 390"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Deal Type
[/TD]
[TD]Lender Name[/TD]
[TD] Deal Type ID
[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]Net Direct Auto Sales[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]Net Direct Auto Sales
[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]WELLS FARGO DEALER SERVICES[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]WELLS FARGO DEALER SERVICES
[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]WELLS FARGO DEALER SERVICES
[/TD]
[/TR]
</tbody>[/TABLE]
Second worksheet:
[TABLE="width: 442"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Lender Name
[/TD]
[TD]Deal Type
[/TD]
[/TR]
[TR]
[TD]A+ FEDERAL CREDIT UNION[/TD]
[TD]Outside Finance[/TD]
[/TR]
[TR]
[TD]AAFES FEDERAL CREDIT UNION[/TD]
[TD]Outside Finance[/TD]
[/TR]
[TR]
[TD]ABILENE TEACHERS FCU[/TD]
[TD]Outside Finance[/TD]
[/TR]
</tbody>[/TABLE]