If not working properly

[hooty22]

I currently have two pages in a book. One page is an inventory page. It has all inventory listed. The second page lists all the shipping information for any inventory that is out.

I want an availability column on the first Inventory page to state Yes if the inventory name is not listed on the second page. I want it to read No if the inventory is listed on the second shipping page. I tried =IF((Inventory!A4='Shipping Information'!$A:$A), "NO", "YES") but it is not working correctly.

Please help

 

[MrKowz]

Try out the MATCH function.

=MATCH(Inventory!A4,'Shipping Information'!$A:$A,0)

However, this will return #N/A! when it does not find a match. To handle this, we put it inside of an IF(ISERROR function.

=IF(ISERROR(MATCH(Inventory!A4,'Shipping Information'!$A:$A,0)),"YES","NO")

 

[Weaver]

try:

=IF(countif('Shipping Information'!$A:$A,Inventory!A4)=0, "NO", "YES")

 

[T. Valko]

I currently have two pages in a book. One page is an inventory page. It has all inventory listed. The second page lists all the shipping information for any inventory that is out.

I want an availability column on the first Inventory page to state Yes if the inventory name is not listed on the second page. I want it to read No if the inventory is listed on the second shipping page. I tried =IF((Inventory!A4='Shipping Information'!$A:$A), "NO", "YES") but it is not working correctly.

Please help

Here's one way...

=IF(COUNTIF('Shipping Information'!$A:$A,Inventory!A4),"No","Yes")

 

[hooty22]

Still not working properly. I do have drop boxes in the second page that are populated with the data from the Inventory page. Is that preventing me from using the IF function?

 

[hooty22]

ARGH. It will work properly for the first 3 items on the Inventory sheet, but will not find the remaining data on the second sheet.

 

[MrKowz]

Can you give us a sample of your data? There could be underlying issues.

 

[T. Valko]

ARGH. It will work properly for the first 3 items on the Inventory sheet, but will not find the remaining data on the second sheet.

See this. It describes common problems when trying to do data matching.

http://contextures.com/xlFunctions02.html#Trouble

 

[hooty22]

I <3 =Clean... I don't know why it works, but it does. Thanks so much for the help everyone!