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...
bg3075 how about:
=iferror(VLOOKUP(V2,Sheet3!$AD:$AD,1,FALSE),VLOOKUP(V2,Sheet3!$AE:$AE,1,FALSE))
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.