Spreadsheet: 834696d1688003937-text-based-on-two-cells-2020companies-example
Sheet: Sheet1

IF data here - populate in column c | If No Data in A, search for keyword in B, populate in C. (Keywords are in column E here to help with formula, but will only exist in column B on actual file) | [NAME] to pop up what's shown below. |  | Keywords to look for in B
BARCLAY DAMON LLP |  | BARCLAY DAMON LLP
CT CORPORATION SYSTEM |  | CT CORPORATION SYSTEM
CT LIEN SOLUTIONS |  | CT LIEN SOLUTIONS
J. TAYLOR & ASSOCIATES, LLC |  | J. TAYLOR & ASSOCIATES, LLC
KONICA MINOLTA |  | KONICA MINOLTA
KONICA MINOLTA BUSINESS SOLUTIONS USA, INC. |  | KONICA MINOLTA BUSINESS SOLUTIONS USA, INC.
KONICA MINOLTA PREMIER FINANCE |  | KONICA MINOLTA PREMIER FINANCE
MEDHQ LLC |  | MEDHQ LLC
MEDICAL EQUIPMENT RESOURCES & CONSULTING |  | MEDICAL EQUIPMENT RESOURCES & CONSULTING
MEDTELLIGENCE LLC |  | MEDTELLIGENCE LLC
TAYLOR COMMUNICATIONS INC |  | TAYLOR COMMUNICATIONS INC
VMG HEALTH |  | VMG HEALTH
WALLER LANSDEN DORTCH & DAVIS, LLP |  | WALLER LANSDEN DORTCH & DAVIS, LLP
WHEELER STAFFING PARTNERS, INC. |  | WHEELER STAFFING PARTNERS, INC.
WHITE SANDS SALES TAX CONSULTING, LLC |  | WHITE SANDS SALES TAX CONSULTING, LLC
[NAME] |  | [NAME]
WILLIS TOWERS WATSON US LLC |  | WILLIS TOWERS WATSON US LLC
WILLKIE FARR & GALLAGHER LLP |  | WILLKIE FARR & GALLAGHER LLP
WISCONSIN DEPARTMENT OF REVENUE |  | WISCONSIN DEPARTMENT OF REVENUE
WOMBLE BOND DICKINSON US LLP |  | WOMBLE BOND DICKINSON US LLP
ZRG PARTNERS LLC |  | ZRG PARTNERS LLC
 | JE Entry BARCLAY DAMON LLPmisc text here | BARCLAY DAMON LLP |  | BARCLAY | BARCLAY DAMON LLP
 | JE Entry CT CORPORATION SYSTEMmisc text here | CT CORPORATION SYSTEM |  | CT Corp | CT CORPORATION SYSTEM
 | JE Entry CT LIEN SOLUTIONSmisc text here | CT LIEN SOLUTIONS |  | [NAME] | CT LIEN SOLUTIONS
 | JE Entry J. TAYLOR & ASSOCIATES, LLCmisc text here | J. TAYLOR & ASSOCIATES, LLC |  | [NAME] | J. TAYLOR & ASSOCIATES, LLC
 | JE Entry KONICA MINOLTAmisc text here | KONICA MINOLTA |  | KONICA | KONICA MINOLTA
 | JE Entry KONICA MINOLTA BUSINESS SOLUTIONS USA, INC.misc text here | KONICA MINOLTA BUSINESS SOLUTIONS USA, INC. |  | KONICA | KONICA MINOLTA BUSINESS SOLUTIONS USA, INC.
 | JE Entry KONICA MINOLTA PREMIER FINANCEmisc text here | KONICA MINOLTA PREMIER FINANCE |  | KONICA | KONICA MINOLTA PREMIER FINANCE
 | JE Entry [NAME] text here | MEDHQ LLC |  | MEDHQ | MEDHQ LLC
 | JE Entry MEDICAL EQUIPMENT RESOURCES & CONSULTINGmisc text here | MEDICAL EQUIPMENT RESOURCES & CONSULTING |  | MEDICAL | MEDICAL EQUIPMENT RESOURCES & CONSULTING
 | JE Entry MEDTELLIGENCE LLCmisc text here | MEDTELLIGENCE LLC |  | MEDTELLIGENCE | MEDTELLIGENCE LLC
 | JE Entry TAYLOR COMMUNICATIONS INCmisc text here | TAYLOR COMMUNICATIONS INC |  | TAYLOR | TAYLOR COMMUNICATIONS INC
 | JE Entry VMG HEALTHmisc text here | VMG HEALTH |  | VMG | VMG HEALTH
 | JE Entry WALLER LANSDEN DORTCH & DAVIS, [NAME] text here | WALLER LANSDEN DORTCH & DAVIS, LLP |  | WALLER | WALLER LANSDEN DORTCH & DAVIS, LLP
 | JE Entry WHEELER STAFFING PARTNERS, INC.misc text here | WHEELER STAFFING PARTNERS, INC. |  | WHEELER | WHEELER STAFFING PARTNERS, INC.
 | JE Entry WHITE SANDS SALES TAX CONSULTING, LLCmisc text here | WHITE SANDS SALES TAX CONSULTING, LLC |  | WHITE | WHITE SANDS SALES TAX CONSULTING, LLC
 | JE Entry [NAME] text here | [NAME] |  | [NAME] | [NAME]
 | JE Entry WILLIS TOWERS WATSON US LLCmisc text here | WILLIS TOWERS WATSON US LLC |  | WILLIS | WILLIS TOWERS WATSON US LLC
 | JE Entry WILLKIE FARR & GALLAGHER LLPmisc text here | WILLKIE FARR & GALLAGHER LLP |  | WILLKIE | WILLKIE FARR & GALLAGHER LLP
 | JE Entry WISCONSIN DEPARTMENT OF REVENUEmisc text here | WISCONSIN DEPARTMENT OF REVENUE |  | WISCONSIN | WISCONSIN DEPARTMENT OF REVENUE
 | JE Entry WOMBLE BOND DICKINSON US LLPmisc text here | WOMBLE BOND DICKINSON US LLP |  | WOMBLE | WOMBLE BOND DICKINSON US LLP
 | JE Entry ZRG PARTNERS LLCmisc text here | ZRG PARTNERS LLC |  | ZRG | ZRG PARTNERS LLC
 | JE Entry BARCLAY DAMON LLPmisc text here
 | JE Entry CT CORPORATION SYSTEMmisc text here