hi all,
I need a formula!
BH1 = 3/31/2013
C = 2635467
J = 2212.50
Look in Column B and match to BH1 AND Look in Column E and match to C3
If both of those match give me the value in Column J
I have this but it won't give me the value in Column J, it says 0:
=INDEX(J:J,MATCH(1,(B:B=BH1)*(E:E=C3),0))
Thank you!
Your formula works but it's an "array formula" that needs to be confirmed with CTRL+SHIFT+ENTER
Put the formula in a cell, press F2 key to select formula then hold down CTRL and SHIFT keys and press ENTER so that curly braces like { and } appear around formula.
Probably best to use restricted ranges rather than the whole columns though, otherwise the formula may be slow.....
Audere est facere
I forgot to mention that it was in Array formula. Came back with the answer 0 and not the value for that cell. I will restrict the ranges.
Hello,
You can try these:
=INDEX(J:J,MATCH(BH1&C3,B:B&E:E,0))
=SUMPRODUCT(--(B:B=BH1),--(E:E=C3),J:J)
The first one is an Array formula though.
Hope this help.
(copy pasta from Ford)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
Regards,
Lem
It works OK for me, see attached with formula in D3Originally Posted by ENAPo
The second formula worked. Thank you!
daddylonglegs,
I was trying to simplify it by not mentioning that a lot of the data is on another worksheet. I wonder if that was what mixed it up??
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks