need a return value macro

[Tonyk1051]

for TT.xlsm heres a link to the tester file

(real file will have differnt amount of lines anywhere from 50- 5000. tab names and headers will always be the same)

In Not on a Category tab, column D will have random vendor names, its different every day.
Vendor Policy tab column has every single vendor in column A
If any vendors in Not a Category tab match with column A in Vendor Policy tab then check if there is a yes in column J of vendor policy tab. If its yes then put in column H of Not a Category tab TT

so example tab1 column D has 1 source video.
tab3 has 1 source video also and column J is yes so i manually put TT in coulmn H not a category tab

thanks in the advance for the macro

 

[Alex Blakenburg]

Thanks for letting us know. Glad we could help.