Need help with the below formula.
=IF(B2<>"",VLOOKUP(A2,Dell!A1:K546,11,FALSE),"")
When B2 is blank, vlookup is gonna refer to sheet dell and give me reference values.
I need to incorporate in the same formula, were for the NA from the previous vlookup, excel should do a vlookup to another sheet.
Just add it onto the end of your formula in place of the ""......
=IF(B2<>"",VLOOKUP(A2,Dell!A1:K546,11,FALSE), VLOOKUP(A2,your-other-reference,11,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
Try This, make some changes
=IF(B2<>"",if(VLOOKUP(A2,Dell!A1:K546,11,FALSE)="NA",VLOOKUP(A2,Sheet2!A1:K546,11,FALSE),VLOOKUP(A2,Dell!A1:K546,11,FALSE))
Regards,
Suhas
Thanks for the response. Request you to check the attachment.
Column 2 and column 3 or different vlookups
I am trying to eliminate 2 different columns and looking for a formula to combine it as one
Thanks in advance
Try this, copied down...
=IFERROR(IFERROR(VLOOKUP(A2,Sheet2!$A$1:$B$546,2,),VLOOKUP(A2,Sheet3!$A$1:$B$59,2,)),"Not Found")
that worked like a champ ...... thankzzzzzzzz a lottt FDibbins
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks