Match two columns across sheets and based on criteria of another column

[tarakul]

Hi All

This is driving me nuts. What I have is:

Sheet1:
ColumnB - number stored as text (Work ID)
Remaining Columns: - mixed data, some columsn numbers, some text

Sheet 2

ColumnA - number stored as text (Work ID)
ColumnB:ColumnAW - mixed data, some columsn numbers, some text
CollumnAX - Dollar Values

What I want is in Column F (Sheet1) a formula to:

if workID in Sheet1!ColumnB is present in Sheet2!ColumnA AND Sheet2!ColumnAX>1 then return True

This must be possible - Please Help

Thanks

 

[Aladin Akyurek]

is there an advantage over the second method than the first?

SumProduct is not a look up function. Used as such with no control regarding the values in the ranges to process, might lead to undetected erroneous results.