LinkBack URL
About LinkBacks
File attached
( Expected results quoted too )
Lookup A into E , if not finds , plug NOT IN SYSTEM
Lookup A into EF , if it finds stock greater than 0 , plug HAVE
File attached
( Expected results quoted too )
Lookup A into E , if not finds , plug NOT IN SYSTEM
Lookup A into EF , if it finds stock greater than 0 , plug HAVE
Try this
B2=>Formula:
Please Login or Register to view this content.
C2=>Formula:Please Login or Register to view this content.
Regards
I know you marked as solved but in case you are open to an alternative and have a larger data set, these two formulas will offer a different approach...
a) For B2 copied down =IF(IFERROR(VLOOKUP(A2,E:E,1,FALSE),"")="","NOT IN SYSTEM","")
b) for C2 copied down =IFERROR(IF(VLOOKUP(A2,E:F,2,FALSE)=0,"","HAVE"),"")
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks