Re: vba script to return multiple results to a single cell using vlookup type formula
yes everything worked out great, the suggested change in offset corrected the problem. I added several VBA scripts with similar names to the workbook and I was blindly changing the wrong one, not the one actually called upon in my formula. A very silly mistake. I was distracted by not understanding the code and messed up. there was no way for you guys to replicate my user error but I truly appreciate your patience.