Hi There
Can I please ask for assistance with these two;
1.Rewrite the formula as my actual sheet is huge and taking 20 + to recalculate
XLOOKUP(1,('Costing and Recipe'!$A:$A=Sheet1!$A$3)*('Costing and Recipe'!C:C=Sheet1!$E$1),'Costing and Recipe'!$D:$D,"")
2.A simple formula to calculate cost column and it is very Manual
Currently it is Cost Value =(E3*E2)+(F3*F2)+(G3*G2)+(H3*H2)
Thanks a bunch
Change your XLOOKUP to this, then copy across and down:
Formula:
Please Login or Register to view this content.
Then your sum will work.
But you can change it to this, copied down:
Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Or, you could do all the sums in one go:
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks