Forum Discussion
search worksheet for a value and return entire row to another worksheet
This revision of what you posted now contains my comments in response to yours. Yours made sense, although as you'll see, I have approached it (as does XLOOKUP) from a slightly different perspective.
So now you can let me know if you have any questions. I am only matching column A with column E, because that seems to be the only column with data comparable to that in A. XLOOKUP then can return the values from all the other columns in the rows where there is a match. I think this accomplishes what you want, but if not, let me know.
The whole purpose was to remove items no longer carried from the inventory database. I can run this for the entire database, filter out "No Match", then copy matches to csv file for importing into our new POS system.
This work for me!
Thank you so much for your patience and of course the help. I enjoyed "meeting" you. I may be back later with more questions 🙂
Have a blessed day!