Forum Discussion
Lookup to return TRUE or FALSE
To achieve this, you can use a combination of Excel functions like COUNTIFS or SUMPRODUCT to check if both the Store Number and Product Number are present in the same row of your data. If they are, it will return TRUE; otherwise, it will return FALSE.
Assuming your data is in columns A (Store Number) and B (Product Number), and you want the TRUE or FALSE result in column C, you can use the following formula in cell C1:
=IF(COUNTIFS(A:A, A1, B:B, B1) > 0, TRUE, FALSE)
Or using SUMPRODUCT:
=IF(SUMPRODUCT((A:A=A1)*(B:B=B1))>0,TRUE,FALSE)
Drag this formula down for all the rows in your data. It will check if the combination of Store Number and Product Number exists in the same row and return TRUE if they do, and FALSE if they do not.
This formula does not require a helper column and should give you the desired TRUE or FALSE result in column C based on the presence of both Store Number and Product Number in the same row of your data.The text and steps were created with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark them as helpful!
This will help all forum participants.