|
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
I need help with a formula.ย I attached the spreadsheet for reference. I need to do multiple vlookups to a periodic table and multiply and add all the numbers for several vlookups and it needs to be all in one formula.ย Please take a look at my file attached.ย Is there a better function I need to use?
Thank you in advance!
Doing all that in one formula is probably asking for trouble. Using a helper cell or two will make it much easier to write / test / maintain.
cheers, Paul
p.s. no attachment showing. Try zipping it up and attaching.
Hi, agree with PaulT, try splitting up, in my case it’s usually inserting columns, into simpler formulas.ย You can always hide / group unnecessary columns after you’re done and it makes things easier when someone else is auditing your work.
Take care,
IT Manager Geek
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
