Forum Discussion
Solved
Attempting to match values from two columns in a separate worksheet
Hi, I am not very experienced with coding. I have two worksheets, in one a column of values that I would like to lookup in the second worksheet (from two columns) and enter in another column if matc...
Yes, that is exactly it. Thank you!!
That definitely helped resolve a few more rows of data. I wonder if it would be possible to maybe extend this to check if a range of numerical (address) values are within a range of the values in the other spreadsheet (if the street names match). I'm thinking that may only be something possible to pursue in the vba editor though.
Possible, very likely, but it may get a bit messy. Can you be more specific about what you need? Maybe start a new thread with this updated request as there are some here that are particularly skilled at doing multiple arrays using LET and other functions.