Match dates and return cost

[Derek M]

down vote favorite ​

​

Forgive me for posting a question that has been asked many times, but I have waded through every answer I can find and no luck.
I have 2 sheets (2018 & Income).

On 2018 I have dates in J7:J44.
On 2018 I have Letters in K7:K44.
On Income I have dates in B1:B69.
On Income I have cost in C1:C69

For example, If a date in Income B1:B69 matches (a date in 2018 J7:J44 and the letter in 2018 K7:K44 is L Upper or Lower case)
I would then like the cost from Income C1:C69 printed in Income D1:D69, else Income D1:D69 left blank

Hope this is explained enough as I am completely new to excel and I am on a very long learning curve.

Everything I try does not work out and I am tearing my already depleted hair out.
Can anyone help me?
I am using Excel 2016
Thanks in advance
Derek M


​

 

[Derek M]

I Should have mentioned.
I prefer Not to use VBA if at all possible.

 

[Marvinexcel]

Hi Derek,

I don't have a clear view of your data, but maybe this can help. Paste the formula in D1 then press ctr+shift+enter. Drag down until D69

=IFERROR(IF(Income!B1='2018'!$J$7:$J$44+SEARCH("L",INDEX('2018'!$K$7:$K$44,MATCH(Income!B1,'2018'!$J$7:$J$44,0)))>1,C1,""),"")

 

[Derek M]

Hi Derek,

I don't have a clear view of your data, but maybe this can help. Paste the formula in D1 then press ctr+shift+enter. Drag down until D69

=IFERROR(IF(Income!B1='2018'!$J$7:$J$44+SEARCH("L",INDEX('2018'!$K$7:$K$44,MATCH(Income!B1,'2018'!$J$7:$J$44,0)))>1,C1,""),"")

Hi
Thanks for your extra fast reply
Unfortunately I did exactly as you suggested and all I get is blank cells in column D.
At least a few of them would have some returns.

Would it be easier if I mover the info on Income to the 2018 Sheet?

If it is possible and I can figure out how to do it, I can post a copy of the workbook with a full explanation, the info on it is only for test purposes at the moment, so the is no private data.

Thanks again.

 

[Aladin Akyurek]

Your request reads as follows:

In D1 of Income, control+shift+enter, not just enter, and copy down:

=IF(ISNUMBER(MATCH("L",IF('2018'!$J$7:$J$44=$B1,'2018'!$K$7:$K$44),0)),$C1,"")

 

[markmzz]

Forgive me for posting a question that has been asked many times, but I have waded through every answer I can find and no luck.
I have 2 sheets (2018 & Income).

On 2018 I have dates in J7:J44.
On 2018 I have Letters in K7:K44.
On Income I have dates in B1:B69.
On Income I have cost in C1:C69

For example, If a date in Income B1:B69 matches (a date in 2018 J7:J44 and the letter in 2018 K7:K44 is L Upper or Lower case)
I would then like the cost from Income C1:C69 printed in Income D1:D69, else Income D1:D69 left blank

Hope this is explained enough as I am completely new to excel and I am on a very long learning curve.

Everything I try does not work out and I am tearing my already depleted hair out.
Can anyone help me?
I am using Excel 2016
Thanks in advance
Derek M
​

Hi Derek!

If I understand correctly what you want, maybe the formula below can helps:

In D1 in the sheet Income and copy down

=IFERROR(IF(VLOOKUP(B1,'2018'!$J$7:$K$44,2,0)="L",C1,""),"")<strike></strike>

Markmzz
​

<strike></strike>

 

[Fluff]

Cross posted https://superuser.com/questions/1314108/match-2-cells-on-different-sheets-and-return-a-third#

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.