•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Find Value to the Left
Our take
Are you grappling with the challenge of looking up a value in a row and returning the corresponding value to the left, especially when your target value resides in different columns across 3,500 rows? You're not alone. While XLOOKUP is a powerful tool, it falls short when faced with this unique layout. Fortunately, there’s a straightforward formula that can resolve this issue and return the desired value—or itself if not found.
Is there a formula that will look up a value in a row and return the value to the left. The value to find is in a different column on each row. And if that value isn't in the row then return itself. I’m familiar with Xlookup but that doesn't work because the value is in different locations depending on the row. I've tried If statements, but I'm stuck on pulling the value to the left. Thank you.
Here's an example of the data. Actual data is about 3,500 rows.
THANK YOU SO MUCH!! IT worked. I really appreciate it.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Formula to read the furthest cell in a row and assigning a value to itI don't know where to begin with this. I believe I need some combination of a LOOKUP and IF statement, but I'm just not sure. I want to have a function that returns text based on the right-most cell with data in it, ignoring empty cells in-between. For instance, if there are three cells with values along the same row, two blank cells after those, and a final cell containing a vale, I'd like the function to return text based on the final cell having a value. Is that possible? submitted by /u/SillyPhillyDilly [link] [comments]
- Need to return a value based on two different search criteria, multiple lines, VLOOKUPHi All, I have a report that I run at work that doesn't come out in a way that makes it easy to work with in an excel spread sheet. The best i can get it is a txt file that when pasted spreads values into different cells. I use VLOOKUP in other sheets to find one value and return another value in the same row. I don't know how to (or if it's even possible) to do this with multiple values on different rows. Could really use some help. I need some sort of VLOOKUP/XLOOKUP type of formula that does the following: -Searches Column A for a specific value -Then Searches Column B (Below where Column A value was found) for another value -Returns the value in Column C (Same Row as B) based on the value from B I'm pretty much stuck using Excel for this as my company doesn't allow outside/other programs to further organize the data. Macros may also be an option if anyone knows any. Thanks in advance with any answers. submitted by /u/QuandoOmniFluncas [link] [comments]
- Search values in 1 array then return the value of another column, same row.Using the example table, I'd like to search column 1 for data limited to a range of 0.220 to 0.200 (r5c1 here) and return the value in another colum of the same row (r5c4 here). Thanks https://preview.redd.it/b1127zmvf8qg1.png?width=302&format=png&auto=webp&s=d5a89be7b832ac7536f171eedd7fd3e78c028dce submitted by /u/SkyChef [link] [comments]
- Lookup in table, return a formulaIs there a way to lookup a name/value of a cell in a table and the resulting answer is a formula? I am wanting to build a calculation, which could use 1 or more variables, depending on the value of a dropdown menu (Im assuming a drop down, since that would force the exact name/format of the formula callout). https://preview.redd.it/bhib489h9fpg1.png?width=1115&format=png&auto=webp&s=c79605dbb3388ec2e3471e60aecb4dd1f304bcfd Above is a quick and dirty example. If in Cell8, there is a drop down that listed the values in column J (1 Face Area, Length Face Area, etc.). In Cells D-F8, a user can input the thickness, length & width. Cell H8 would lookup the value from C8, reference the table from J5:K11, and after finding the formula, it will do the appropriate calculation. What I listed as a formula is just text for the example. I am open to adjusting as needed. This is just an example. I know I could do a bunch of imbedded IF statements in this example, but assume the table from J5:K11, could be many many lines. The table could be as many columns and rows as needed. Further, the example is just a single line (row 8), the intent would be to have many (10's, 100's or even 1,000's) rows of data, so calculating the answers and looking those up the table wouldn't work, like a single line entry. Is this even possible? I would prefer to accomplish this without VBA, if possible. EDIT: Here is another version of the example. As you can see I am planning on having multiple lines of entries. Some will have the same dropdown formula requested (i.e. Length Face Area), while others may never be requested. Hopefully that clarifies a bit. Also, while I would prefer to do without VBA, if that is the "easiest" solution, I am not opposed to entertaining. https://preview.redd.it/kqil9xiljfpg1.png?width=759&format=png&auto=webp&s=71f6d68f69bd0f6a5550d256b344032d7bc9ccbb submitted by /u/ernstm63 [link] [comments]
Tagged with
#row zero#Excel alternatives for data analysis#rows.com#big data management in spreadsheets#generative AI for data analysis#conversational data analysis#real-time data collaboration#intelligent data visualization#AI formula generation techniques#Excel compatibility#financial modeling with spreadsheets#lookup#value#row#return#column#Xlookup#data#If statements#left