Get Excel to go through a list to do a match

[locopete999]

Hi All,

Can someone please check the below.

I keep getting an error at the Next B saying that there is a Next without a For?

Please Login or Register  to view this content.

[Marc L]

Hi !

Yes, just a logic error as your Next B codeline is within an If block beginning after the For codeline ‼

So this Next B must be outside of this If block, after its End If codeline closing this block …

[locopete999]

Thanks Marc,

Next problem.

I'm trying to look up in the AllGBComputers sheet and find where it matches a list on the Lotus Notes Mailbox List.

Once it finds this match i want it to store the value from the match.

However, this is currently running through all the variations from the FOR I and B variations and not returning anything?

Can anyone advise?