#1
|
|||
|
|||
Know-Nothing Excel user needs help with simple Excel operation
Please see the attached word document describing what i want to do and the attached two small excel spreadsheets the word document refers to.
|
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
Know-nothing Excel user follow-up
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 |
Tags |
excel-qb interface |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel to be edited by multiple user but relevant user should see only his data | dolphine4u | Excel | 1 | 07-24-2016 12:40 AM |
Simple Macro help for Excel Solver | ue418 | Excel Programming | 1 | 06-23-2013 12:34 PM |
Simple Excel Formula Help | BlueFunk3 | Excel | 2 | 06-08-2013 06:40 AM |
Simple graph in excel | izzy786 | Excel | 1 | 09-08-2012 08:04 AM |
Basic operation of Excel not working! | praveen_p | Excel | 2 | 04-23-2009 10:21 AM |