Please see the attached word document describing what i want to do and the attached two small excel spreadsheets the word document refers to.

Attached Files

	Example 1 Excel Spreadsheet 1 Date, Transaction Vendor, Amount.xlsx (12.9 KB, 7 views)
	Example 2 Excel Spreadsheet 2-- Date, Transaction Vendor, Account and Amount .xlsx (13.0 KB, 6 views)
	KNOW-NOTHING EXCEL USER NEEDS HELP WITH EXCEL-QUICKBOOKS OPERATION.docx (16.5 KB, 9 views)

Not sure if I totally understood what you need. And, I'm sure there are better ways to do this... But:

This setup assumes that there are patterns in vendor column. It uses wildcards "*"&A1&"*" and if statements to compare the items.

VLOOKUP also allows wildcards, and it would be good to use that because it looks in a range of cells rather than looking in each cell individually (as I have done). I couldn't figure out how to set it up with vlookup for this though... My technique of looking for a pattern cell-by-cell will be okay until you have more than a dozen or so patterns. Then the formula will get a bit cumbersome.



Note also that I have the exported-from-your-bank data in one tab, then the other tab reads from that tab. This prevents you from having to re-enter the 'account' column each time.

Like I said, there are probably better ways to do this!

Attached Files

Example 2 Excel Spreadsheet 2-- Date, Transaction Vendor, Account and Amount .xlsx (15.4 KB, 4 views)

6-18-2021

Mr. Kunkel:

Thank you very much indeed for your reply and your efforts to help me. I am trying to find a way to deal with this problem without resorting to the use of complex formulae; I doubt I will succeed that way. But many thanks.

geobar