•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Search for value in column and compare values to show if they match don't match
Our take
It sounds like you're feeling overwhelmed with your spreadsheet task, specifically when trying to compare values between columns. You're working to determine if the value in column C matches a value in column H, using reference parts from columns A and F. The formula you provided seems to be causing errors, and you're wondering if moving data from columns F onward to a different sheet might help. Let’s explore how to simplify this process and ensure accurate comparisons without the frustration.
Stuck in excel hell for the last while with this heres my problem:
Trying to check if my value in column c is a match to a value located somehwere in column h where colums a and f would contain the reference parts top match them, should i be moving the values from colums f out ward to a different sheet maybe?
using the formula below is spitting out an error.....if anyone can help i'd really appreciate it
=IF(LOWER(TRIM(C2)) = LOWER(TRIM(XLOOKUP(A2, F:F, H:H))), "Match", "Mismatch")
if anyone has any ideas of would know how to do this if moving information from colums f onwards out then please let me know how to do it as I'm at my wits end with this.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Am I not using XLOOKUP correctly? And absolutes $shttps://imgur.com/a/o0alvvv I am basically trying to get column "E" (Billing End) on the "Upload sheet" to populate with the values found in column "C" on the "Data sheet"...ONLY IF the values in Data Sheet (B:B) and Upload Sheet (C:C) match AS WELL AS Data Sheet (D:D) and Upload Sheet (B:B) match. Sorry, I could have organized the columns more alphabetically but I figure you'd get the gist of it and I can play around with the figures. In Upload sheet E2 and pulling formula down, I would put... XLOOKUP(1, ('Data sheet'!D$2:D$7=B2)*('Data sheet'!B$2:B$7=C2), 'Data sheet'!C$2:C$7, "" ) submitted by /u/jwnsfw [link] [comments]
- Return value based on word found in string of text in a cell?I am building a spreadsheet to help budget some expenses and am trying to automate as much as I can. I have a table in Column H with a keyword like "Gas" or "Electric" and then a corresponding category in Column I that groups this into something like "utilities". I have a spreadsheet where I export my bank statement and Column B is the vendor and Column C is the amt. I have Column D trying to group all the expenses based on the helper table in Columns H and I to quick and easy organize all the transactions for a month. I made the formula: =IFERROR(XLOOKUP(B3,ISNUMBER(SEARCH($H$3:$H$35,B2)),I:I),"Uncategorized") to try and get a return and it doesn't work just yet. I feel like I'm close but I'm not as familiar with XLOOKUP as I want and I cant figure out what I could use to make return any easier. Is there a simpler way to get a return like this from a string of text or am I missing something with how the XLOOKUP works? submitted by /u/Pmme10doller_psncard [link] [comments]