Happy New Year all.
I've been using the below formula which works a treat up until now. Where I had one Supplier, I now have multiple but some product names are identical therefore I need to add an additional criteria.
=IF(ISERROR(VLOOKUP(B2,'DATA PULL'!B:B,1,FALSE)),FALSE,TRUE)
The additional data would be in A2 and 'DATA PULL'!A:A
Any help modifying the above formula would be greatly appreciated.
Matt
so you are not looking to pull back the results of the find, just true or false if what is in B2 is in either data pull BB or data pull AA?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
if you are just looking to return a true or false maybe a simple countif like this...
=IF(COUNTIF('DATA PULL'!B:B,B2)+COUNTIF('DATA PULL'!A:A,A2)>0,TRUE,FALSE)
edited, must not have been reading closely enough to notice the A2 part so I adjusted the formula.
Last edited by Sam Capricci; 01-07-2020 at 08:18 AM.
That seems to be giving me a TRUE if either condition is met. I need both conditions to be correct before a TRUE is given
currently I'm just guessing as you haven't given much information about what you are trying to do. How often will it find the value in B2 in either data pull? In other words can what is in B2 be found more than once in data pull B:B?
maybe this... =IF(COUNTIF('DATA PULL'!B:B,B2)+COUNTIF('DATA PULL'!A:A,A2)=2,TRUE,FALSE)
Ditto here, adjusted to A2 though it appears you got it solved anyway, more for the record.
Last edited by Sam Capricci; 01-07-2020 at 08:19 AM.
If you upload a sample file as stated in the yellow banner at the top of this page, you may get better answers, but I'm going to guess here. I think you were comparing a value in column B to another sheet column B, and now you want to compare both values in both A and B to another sheet columns A and B? If so, this may help:
=IF(SUMPRODUCT(--(A2='DATA PULL'!A:A),--(B2='DATA PULL'!B:B))>0,TRUE,FALSE)
Awesome! Thank you. What with "--"? I had something similar that didn't work, what does this do to the formula?
The "--" changes a True or False to a 1 or 0.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks