I'm having problems with VLOOKUP formulas that look to external workbooks.

Some of my VLOOKUPs to other workbooks work fine, but others in this file (looking to the SAME external workbooks as the properly working formulas) only work if I *open* that other workbook. If I don't have the other workbooks open, the problem formulas return #N/A.

The formulas (working vs. not working) are in tables on different tabs. All the workbooks are saved in the same shared drive.

Any ideas on the issue?

Hedge fund or VC route?

Hi guys...I am currently working as a process executive at Infosys BPO.. with a very basic salary of 16k..any professional advice on how can I get a salary hike here?
Any help will be much appreciated

Why Capgemini calling back it's employees...can't it wait till June..

Hi ,

Need 11 likes for DM access .

I hope he’s in as much pain as I am. The way he ended it was so cold and selfish and unlike how he was any other time with me. It was like a personality switch. I’ve never been so wrong about someone. I’m not sure how to process or recover from that part of it.

Would you consider corp dev & strategy “back office”?

Hello all,

Does citi provide guest house for few days if we are going to work location from base loacation for 2 days.

Plase give ur thoughts on this.

What will be salary in hand if fixed offered package is 28.5 lakh in citi?

Just started at the firm a month and half ago and snapshots are already happening soon. How important are they? I’ve had pretty low utilization, so I’m kinda nervous as an experienced hire

Question for my 401k focused advisors out there--what programs are you using that is instrumental to your 401k practice that you simply can't do without? I'm being pitched on Envestnet & im not sold.

I’m a senior planner leading one brand and there’s a new strategist on the team working on a sister brand. They’ve been asking for every strategy deck I’ve made on that brand as an example to go by to inform the thinking/flow on the sister brand. Also because I mentioned it went well with client when they ask. All for sharing thinking w/ the team & I know we feel imposter syndrome to varying degrees, but I also feel like it’s good for planners to find their own voice/style/flow. Thoughts?

Hello All .

Received offer letter today from LTI . It’s mentioned in the mail that i will receive BGV mail After acceptance of letter but no mail received till now .

How much days it take to receive that mail ? And can we mention our joining date (early joining) there ?

Thanks !

Hello all,

Can we switch internally within Accenture India?
Currently I'm working with Accenture operations and I wish to move to Accenture Strategy and Consulting. Please let me know the procedure if anyone is aware of it.

Thanks!

Do you review the other side’s escrow instructions and provide comments? 4 years in and I’ve never done this. Working for a new partner and she insists on doing so “in case there are competing instructions” but isn’t that the entire point of funding through an escrow agent/title company?

Best neighborhoods in Jersey City for starting family soon?

I’m an aspiring musician in the greater Boston area looking to make connections outside of my sporadic work schedule. Are there any recommendations one could share aside from open mic nights? I’m looking for some different ideas

How are you guys survive weekly travel projects? I am really struggling and feeling exhausted all the time. It's a busy one 50 hours a week+ studying for a certification.

How many days/weeks are expected from a candidate (Manager+ level) to accept/decline offer?

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

How do I compare two sheets to make sure they are identical?

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

Would anyone be willing to teach me vlookup?