How to make excel use a if statement for a range of cells

[Tedstonegenious]

So I am trying to see if every name on one excel list also exists on another list, I want to do something like =IF(AT2=AS$2:AS$140, true, false) where AT2 is the name I want to see if it exists in the range of AS$2:AS$140, but it only returns true if the tested name happens to also be the first element of the ranged list. How do i make it test for every name in the ranged list. 

[IkeaGnome]

If it's formatted as a table, you could use a simplified version of this. It checks in the same row. This one throws an error if on hand and ordered is less than my minimum. 

=IFERROR(IF(SUM(InventoryList[@[ON HAND]],InventoryList[@[QTY ORDERED]])<InventoryList[@MINIMUM],1,0),0)

 

My bad. That doesn't do other sheets.

[RevTadd]

=IFERROR((MATCH($C$4,$E$4:$E$10,0)<>0)*1,0)

Where C4 is the value your looking for and E4:E10 is the range. If it is 1 the value exists in the range, if 0 it does not.

[Tedstonegenious]

On 10/27/2020 at 10:56 AM, RevTadd said:

=IFERROR((MATCH($C$4,$E$4:$E$10,0)<>0)*1,0)

Where C4 is the value your looking for and E4:E10 is the range. If it is 1 the value exists in the range, if 0 it does not.

This is not working either There is a clear match in the first colum but ti still reports 0

 

 

[The1Dickens]

9 hours ago, Tedstonegenious said:

This is not working either There is a clear match in the first colum but ti still reports 0

 

 

What flavor of Excel are you using? Your initial solution seems to work, unless I am not quite understanding your predicament.

[LogicalDrm]

-> Moved to Programs, Apps and Websites