Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.
I am very sorry about your issues. Can you send me a sample or dummy Excel file with sample or dummy data so that I can actually work on your requirement and send it back to you for checking?
You can attach the sample Excel file when you reply using the paper clip icon.
Please let me know by replying to me here so that I can help you further.
Thank you. I got the file and there are 2 sheets with highlighted columns: Account Number and Items columns.
Are you working on Column A to fill out "Return Value"?
This is the criteria you mentioned:
I would like SHEET1 A4 to produce the following values: (to be copied to 50,000+ rows) "NEW ITEM" - IF ACCT# : B4 and ITEM# : D4 do NOT match SHEET2 (same colums any row) BLANK - IF ACCT# : B4 and ITEM# : D4 do match SHEET2 (same colums any row) "NEW ACCT" - IF Sheet1 ACCT# : B4 does NOT match SHEET2 ACCT# : column A (any row) "NEW ITEM" - IF ACCT# : B4 and ITEM# : D4 do match SHEET2 (same colums any row) AND Sheet1 TY 90 DAYS : E4 =BLANK or zero AND Sheet1 TY 90 DAYS : E4 = greater than zero
Can you clarify this requirement further? Or can you do an example using the sample file you gave me? For instance, in Sheet 1, A3, what is your expected result?
I am sorry but I cannot follow your described conditions.
In sheets 1, A3 = NEW ITEM because:
Is that correct? But Sheet2M3 is blank.
Thank you for that information. And if ANY of these conditions are NOT met, A3 will show NEW ACCT instead of NEW ITEM. Is this correct?
Thank you for that confirmation. Please give me a moment to build the formula for you.
I have built a formula for you using the conditions you confirmed to me. In the sample file you have me, ONLY Sheet1 A3 resulted to New ITEM. The rest (Sheet 1 A4 to A25) are showing NEW ACCOUNT.
Please check the sample file you gave me with the sample data. Are my results correct?
Ok. Please give me a moment to check the second dummy file
One more thing since the conditions are very complicated. Are you comparing or matching values per exact row? Or are you tying to match the value in Sheet1 to ANY match in the entire column in Sheet 2? I am asking because Sheet 1 has 23 rows while Sheet 2 only has 18 rows. Please confirm if the values in Sheet 1 are to be compared and matched to the entire column in Sheet 2.
For instance, for Sheet 1 A21, how did you determine it will be blank when Sheet 2 data ends in row 20 only?
Thank you for that confirmation that the matching is done per row and not the entire column. Please give me a moment to build the required formula for this.
Thank you for writing back. So are you saying that for instance, Sheet1 B3, it is going to locate a match for the entire column A in Sheet 2 like A2:A50000 ?
Ok. Thank you for the confirmation.
Thank you for writing back and I am very sorry about the late reply. I am still working on this and will finish the required formula in a while. This has become complex when you confirmed that the data in Sheet 1 is to be compared to the entire corresponding column in Sheet 2.
I will keep you posted.
Thank you for writing back and I am glad you fixed the problem. I checked your formula and it will not work according to what you have described to me. The scenario you described based on the sample file you gave me was far too complex compared to the formula you said that worked. My formula accommodates dynamic data and uses match function since VLOOKUP will not work in the scenario you described to me. I am almost done with the complex logic and the final formula but I believe you no longer need it.
Yes, we guarantee our service so you can always get your money back. Please use the link below for more information about refunding:
I am sorry if I was not able to help, or was unable to finish the requirement you need.
Thank you for using our service.