•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
Tagged with
#Excel alternatives for data analysis#Excel compatibility#financial modeling with spreadsheets#Excel alternatives#natural language processing for spreadsheets#generative AI for data analysis#rows.com#AI formula generation techniques#formula generator#Excel#column#match#value#reference#XLOOKUP#formula#error#TRIM#LOWER#mismatch