hi all,
i trying to use vlookup to search for a value in sheet "data" column A and search in sheets “import1, import2, import3” and return a value from column B.
This is what I’ve been playing with:
=IF(ISERROR(VLOOKUP($A1,import1!A:B,import2!A:B,import3!A:B,2,FALSE)),"",VLOOKUP($A1,import1!A:B,import2!A:B,import3!A:B,2, FALSE))
with no luck
Is there a way of using vlookup to search multiple sheets?
Any help would be appreciated.
thanks
Bookmarks