•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Auto filling not "counting" when using VLOOKUP
Our take
In the world of spreadsheets, efficiency is key. This guide explores how to leverage VLOOKUP for auto-filling team names based on contestant inputs. The top left quadrant demonstrates this functionality effectively, but what happens when you need to replicate this across different quadrants? Instead of manually entering formulas, you can use a combination of absolute and relative references to streamline the process. Discover how to maintain dynamic calculations effortlessly, ensuring your data remains accurate and your workflow efficient. Let’s transform your spreadsheet experience together.
Example Sheet. The top left quadrant is correct. When you type in the contestant name, it will auto populate their team. When you copy and paste to another quadrant, how do you make it to do the same calculation without manual inputting every formula?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to autofill data from a row to a column on a different sheet in the same folder?I've been struggling with some solutions I've found on the forum but after 1.5hrs I'm close to giving up and manually entering data - which is bound to cost me another 28 hrs. Hoping someone has the solution I'm looking for and is willing to share.. I've exported questionnaire results from Mentimeter to Excel. The document output is formatted automatically in a way that uses columns for unique respondents, followed by their answers in the same column but along individual cells on that column's row, meaning the first entry is A2 and the last entry is in cell CQ2 or something. I would like to make this more user-friendly by: 1) putting each respondent's answers in their own sheet in the folder, and 2) by listing the questions in the first column and the answers in the next columns pretty much 'the other way around'. Currently it looks like this; the answers I need are listed in !VotersF3 to !VotersCQ3. The next respondent's answers are in !VotersF4 through to !VotersCQ4 and so on. What I'm looking for would ideally display answers in !AnswerA3 through to A80. When I manually select !AnswerA3 and click on !VotersF3, logically it does what I want. When I then drag down to autofill, equally logically the sheet enters !VotersF4 instead of !VotersB3 as it's a row vs column problem. I've tried different version of INDEX and TRANSPOSE but I can't get a working formula from that. Would anyone be able to provide me with the correct solution for doing this? I've got another 20+ respondents answers that need to be 'easy to view' instead of scrolling 500 screens horizontally.... Thank you Excel wizards! :) submitted by /u/Lost_Mud2097 [link] [comments]
- What formula should I be using to populate one column’s data automatically based on my entry for another column?Hi! I need some help here. first off, I’m not allowed to use a v-lookup for this file due to some organisational restrictions, so i’m unable to create a table 2 to facilitate the lookup values. I’m only allowed to use table 1 itself, which is where I have to put in all my values. I have been trying to use index/match instead but can’t see to figure the right formula out. so basically, what I need is for my manual input of data in column J to populate the associated remark in column K. • column J input “NA” = column K input “visit 2” • column J input “nil” = column K input “insufficient blood” • column J input “1” = column K input blank these are the only 3 that I require. let’s say I require it for 30 rows. so my range of rows to populate would be K2:K30 based on the directly adjacent data of J2:J30. how can I do this in formula or automation? thanks in advance! submitted by /u/yanny-jo [link] [comments]
- Returning multiple matches per ID (auto-fill when dragged down?)Hi there! I have multiple assigned IDs for a single code so I need to return all matching values, not just one. I also want this to be kind of automated (?) when I drag down the upstream ID column, it can pull all corresponding values, even if they share or don't share the same code I tried using FILTER, but it only spills results in one place and doesn’t carry over properly when dragged down for other rows. I don’t want to adjust ranges every time manually since my data might get longer. Is there a way to make a formula that: works when dragged down, returns multiple matches per ID, and still updates properly even if the data goes beyond the current rows? Left Side = source workbook; Right Side = destinatioon workbook Thank you so much in advance! submitted by /u/jeankrstein [link] [comments]
- Vlookup / Index disappearingApologies if I'm asking a really dumb question, I am somewhat new to excel. I'm having a problem with a macro-enabled workbook. I have tried both Index and Vlookup, but both formulas just disappear and only leave behind the last value they found. Attached is a massively simplified (and ugly) version of what the spreadsheet is supposed to do. The issue I'm having is that every time I add anything new into the empty slots of column B, Vlookup completely disappears from the cell it's in and just leaves behind "Item B" or whatever the last value it searched for was. Is this supposed to work this way? I also tried Index, and the result was the same. I don't know how to figure this out without manually re-writing the formula every time the list of items changes, which is a huge pain. Thanks for any help. https://preview.redd.it/ceyghyu6t0rg1.png?width=627&format=png&auto=webp&s=1e0a247397d39b1a050841f1ada44b14b8d5fae8 submitted by /u/allegedlyautistic [link] [comments]