•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
What formula should I be using to populate one column’s data automatically based on my entry for another column?
Our take
To automate the population of one column based on entries from another without using VLOOKUP, you can utilize the IF function in your spreadsheet. Since you need to populate column K based on specific inputs in column J, an effective formula would look like this: `=IF(J2="NA", "visit 2", IF(J2="nil", "insufficient blood", IF(J2="1", "", "")))`. You can apply this formula to the range K2:K30 to ensure that each row reflects the corresponding entry from column J. This approach simplifies your data management while adhering
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!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- If K2 equals X1 (pulled from sheet 2) then I2 equals X2 (pulled from sheet 2)I am trying to create a formula where I have a drop down in column K linked to sheet 2 column 1. I want column I in sheet 1 to auto populate based on the response from dropdown K. To be specific, column K contains GL names (office supplies, miscellaneous, lunches, etc.), and I want all office supplies to be 5200, misc. to be 5300, etc. I keep getting different errors when trying to use XLOOKUP/VLOOKUP/IF. Thank you so much for your help! submitted by /u/batmandi [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]
- Formatting question for automating data entryIm going to try to articulate what I need and if it’s possible to do inside excel. At my job I have to record the amount of patrons using our facilities. and specify what particular services are being used. at the end of each quarter. (3 month period) I must tally up all the numbers and provide a total for each aspect of our facility as well as the total overall. For example. 1st quarter numbers. 100 patrons used theatre. 250 patrons used Game room 450 patrons used computer lab so on and so forth. Now that you have the gist in your head. Imagine a spreadsheet where the first form is just a data entry sheet. it’s essentially just a box that never changes. You input the numbers for the week, and that data gets automatically moved to a different cell that has the total amount. so that at the end of the quarter I can easily see my total without having to backtrack or tediously add. if anyone has some insight on how I can do this Please reach out. If you have any questions about my wording or understanding exactly what I mean please also reach out. If you read all this I appreciate your time. submitted by /u/Beneficial-Yard-9006 [link] [comments]
- Matching Numeric Data across two columns?What I thought would be a simple formula has taken me over 2 hours of searching and no results as yet.. So im reaching out for help please. Heres where Im at. - Using 16.108.2 version - I have 2 sets of data of differing row amounts. There is one numeric column in each set that definitely has matching numbers across them. I need to see which numbers are matching and which numbers aren't. - I need to align those 2 columns where the numbers are matching, and also keep all other information aligned across the columns that are alongside the 2 I am matching. I have tried the XLOOKUP formulas that I can see listed when i do a google search, but i cant get it to work, either some information or step is being left out, or I am finding the wrong info on how to do this. Can anyone provide a step by step on this please? submitted by /u/Sentallmentall [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#rows.com#AI formula generation techniques#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#formula generator#enterprise data management#big data performance#data analysis tools#data cleaning solutions#cloud-based spreadsheet applications#Excel compatibility#automation in spreadsheet workflows#generative AI automation#workflow automation