Somewhat complicated vlookup exercise;
Tab 1=list of work products to complete, 27392 rows, file name in Col A, document title in col C.

Tab 2 = data dump of database 2, 138816 rows, file name in col H, document title in col. K

Tab 3 = data dump of database 3, 13723 rows, document and or file name in col AS, document and or file name in col BO.

Tab 4 cut and paste of tab 1 with vlookups ie "results"

My sample formula is
=vlookup(A2,tab 2!H5,2,False)

I pulled this down all the way to row 27392.

All results "n/a".

Do I need 27392 formula or 138816?
I need to check if the 27392 items in tab1 are present in the lines of tab 2, or the 13723 lines of tab 3.