Hi
Im trying to combine my table array in vlookup to include to sheets within the same file for my vlookup but its not accepting it. Below are the two vlookups that I am using, how can i combine them to search in both?
=VLOOKUP(F5,'P:\Bata\Bond\N20\[Nature 20''s Catalogue DHL.xls]2012'!C:F,4,0)
=VLOOKUP(F6,'[Nature 20''s Catalogue DHL from 2012- .xls]2013'!$C:$I,4,0)
Bookmarks