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.
Bookmarks