Hi all,
I have this ARRAY formula with brackets (CSE entered). However, the formula is only returning the first VLOOKUP value it finds and multiplying that with the rest of the formula.
=SUM(IF(BT8:DQ8 > 0, $C7*VLOOKUP(BT5:DQ5,'Variable Costs Lookup Sheet'!$E$4:$F$546,2,FALSE),0))
Any ideas?
Kind regards,
Les
Hi
Les, it will be good for all of us if you attach a sample sheet.
Regards
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Please find attached,Originally Posted by Fotis1991
The orange shaded formula is the one I originally posted,
The one in green is another that someone else helped me with. However, that one does not add duplicates in the top row.
Many thanks,
Les
Are you sure you attached correct workbook? I don't see the orange and green cells, those formulas or the Variable Costs Lookup Sheet
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Sorry, I did send the right file but the wrong type of file. Please find attached.
However, the problem (with a lot of help from someone else) is now solved with this formula
=SUM($C7*SUM(IF($CP7:$EM7>0,IF('Variable Costs Lookup Sheet'!$E$4:$E$546=$CP$5:$EM$5,'Variable Costs Lookup Sheet'!$F$4:$F$546))))
(this is based on another workbook, but the one attached demonstrates what I was trying to do)
I'd be interested to see what you come up with.
Kind regards,
Les
Is this it?
In V6,
=SUM(U6*SUMPRODUCT((ISNUMBER(MATCH($X$5:$AB$5,$P$23:$P$27,0)))*($X6:$AB6)))
copied down (only need to use ENTER to confirm).
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks