Hello,
I am trying to get this nested loop to work and I keep getting errors.
Can someone please help me fix my code?
I have two sheets with column ranges that I'm comparing text to see if it matches:
Find Stock Symbols
Stock & Symbol Data
Thanks for any help!
Please Login or Register to view this content.
I suggest you post a sample workbook.
I suspect it would be easier to do this with a formula.
It looks as though it would be an INDEX/MATCH as you want to return a value from the column before the one being searched.
Untested, but try:
=IFERROR(INDEX('Stock & Symbol Data'!$A:$A,MATCH('Find Stock Symbols'!$B2, 'Stock & Symbol Data'!$B:$B, FALSE)),0)
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi,
I am not very good at this, but I looks like the loop is incorrect.
"Next y" is before "End IF". Check by replacing "Else" With "End If".
Please Login or Register to view this content.
Try:
Please Login or Register to view this content.
You hit the nail on the head! Switching the "Next y" and "End If" and replacing the "Else" did the trick.
Thanks so much for everyone's feedback.
Hi,
I am not very good at this, but I looks like the loop is incorrect.
"Next y" is before "End IF". Check by replacing "Else" With "End If"....
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Originally Posted by 
Bookmarks