Forum Discussion
VBA or IFErrorVlookup?
Hi everyone, happy Wednesdays! I'm wondering if anyone has any advice for my current Spreadsheet. I'm trying to input contact details into sheet1, and have them carry over to sheet2. In sheet2...
Assuming you have a very current version of Excel, there are a couple of "dynamic array" functions now available--notably SORT and FILTER-- that should do away with the need to write VBA routines to do a lot of what you're apparently doing. Microsoft created a YouTube video that introduces these, and it's a good one (it's where I learned of, and how to use, them.)
Beyond that, I would encourage you, since you're not using full names here, to post a copy of the actual workbook on OneDrive or GoogleDrive, with a link here that grants access to it. Working with the actual workbook is a LOT more helpful than with images.