Oct 21 2020 02:40 AM
I have a data table that looks something like:
My return value datasheet looks something like:
I am trying to say that if Name and Month is matching, then return the value. Otherwise, 0.
Oct 21 2020 02:55 AM
In your picture, for example, you cannot see where the words "Apple, Carrot, etc." takes.
It is not clear what your plan is.
With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. You could get a precise solution much faster with a file (w/out sensitive data). This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.
Thank you for your understanding and patience
Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)
Oct 21 2020 02:55 AM
Oct 21 2020 03:43 AM
@NikolinoDE Thanks for your message. Please see attached excel file. I'm trying to retrieve data from 'Source File' columns EZ to FK and return values in 'Return Value' tab, columns labeled 'Source File'. Thank you!
Oct 21 2020 04:33 AM
Enter the following formula in D3:
=SUMIF('Source File'!$A$4:$A$49,LEFT('Return Value'!$A3,5),OFFSET('Source File'!$EZ$4:$EZ$49,0,(COLUMN()-4)/3))
Adjust the ranges if your data extend below row 49.
Fill down to D5.
Select D3:D5.
Copy the range.
Paste to G3, J3, M3 etc.
Oct 21 2020 07:13 AM
@Hans Vogelaar Works AGAIN! Thank you - you are making my life easy.