Microsoft Office Questions? Ask a IT Expert for Support ASAP
Thanks for using JustAnswer. My name is Andrew, I will do whatever I can to answer your question
if I am to understand you correctly
you have a collumn of account numbers
then a column of other data
and you want to see the other data where ever the number 123 appears in this colllum?
does this about sum it up?
Not quite. Each of the above account numbers you outlined can appear numerous times, each with a different transaction number. If the account 123 appears in a transaction along with any other account number, I want to see that with all associated account numbers.
If you look at the following examples, at the bottom of this example there is a transaction number 95743963 with 2 different account numbers and 4 transactions. Any time the account 812840 shows, i want to be able to select those 4 transactions. Since none of the account numbers above include this account, I am not interested and don't want to include in my data.
I forgot to include the dollar amounts. There would be an amount associated with each of the accounts.
this is sounding way to complicated, i will opt out so another expert can help you
Would some type of nested If statement work?
I did not get a satisfactory answer nor does it appear that you are aware of what I am asking, and I see that my account has been fully charged. Please advise what further information you need so that I can help you to get an appropriate resolution.
You apparently did not read the information I provided earlier. I am not trying to match data to a specific customer. If that were the case I could easily do that with a V Lookup. Again, what I am trying to do is retrieve data with a specific account number, 812840 as shown above, and also pull any additional data associated with that transaction's sequence number. I will be unavailable for a couple of days, so if you need a file I can possibly send to you on Friday. Please provide an email address to which I can send the file.
I’m a moderator for this topic. It seems the Professional has left this conversation. This happens occasionally, and it's usually because the Professional thinks that someone else might be a better match for your question. I've been working hard to find a new Professional to assist you with your question, but sometimes finding the right Professional can take a little longer than expected.
I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.