I have a cell in my workbook with this function:
I'm trying to nest a few more VLOOKUP's into this IF statement. So, if a date isn't in the above workbooks, to cycle through and look them up in 'Lookup2011,' 'Lookup2010'.
Please Login or Register to view this content.
But I'm having trouble nesting them correctly. Excel throws up 'too many arguments' error.
Can anyone advise how to look up more workbooks into the function.
Thank you for your help.
IFERROR() syntax is....
=IFERROR( your-formula, what-to-do-if-your-formula-doesnt-work)
so maybe something like...
=IFERROR(VLOOKUP(A2,Lookup2013,9,FALSE),IFERROR(VLOOKUP(A2,Lookup2012,9,FALSE)...................................)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi,
I tried,
Excel showing a message, saying I've entered too many arguments...Please Login or Register to view this content.
I need the Lookup to cycle through (at least 5 workbooks) until a match is found (if no match is found then leave the cell blank).
not sure see if this works
=IFERROR(VLOOKUP(A2,Lookup2013,9,0),IFERROR(VLOOKUP(A2,Lookup2012,9,0),IFERROR(VLOOKUP(A2,Lookup2011,9,0),IFERROR(VLOOKUP(A2,Lookup2010,9,0),IFERROR(VLOOKUP(A2,Lookup2009,9,0),IFERROR(VLOOKUP(A2,Lookup2008,9,0),""))))))
Click on * below if you find this helpful
Thanks,
A
Exactly what I was looking for. Thank you for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks