Hello,
I need some help, I have a spreadsheet that the columns are not lining up and I need to sum across based on the same data. Columns B3 (April) has 300 rows, Column G3 (May) has 295 rows and Column L3 (June) has 301 rows. I need to do a sum across based on the data in columns B3, G3 and...
Hi Everyone,
I've and been in the project management field for over 5 years and in the IT industry for over 10 years. I'm always looking to learn new tricks with excel and MS Office to help me improve with my job functions each day.
I look forward to having discussions with each of you.
Hi Everyone,
Thank you for all your responses. I know my question is a bit vague but here is what I'm running into.
I have two workbooks one that is called "Lookup Data Example" and another called "Lookup Data Groups" I want to be able to use the vlookup formula in the Lookup Data Example...
I need some assistance, I need to do a vlookup and search data from another workbook and i keep getting the #NA when I do =VLOOKUP(F2,'[File Name.xlsx]Tab Name!$A$2:$F$6146,6,FALSE).
Could someone please help me with this
Many Thanks