Dear all,

I find trouble while trying to do vlookup in Wkbook A, from a row in Wkbook
B. In the table array, it returns #Value! . I'm unsure if this function
allows cross wkbook utilisation. Or is there other possible solutions please?
Thankyou!