Need a formula that will check a cell against a worksheet and return a certain value

ExcelHelpSheet.xlsI've been working on this for the past two weeks and I finally give up! I can't seem to find a similar question that I can tweak to fit what I need. Here is my problem:

I have a list of agricultural commodities that are commonly imported. Some of these are considered "NARP" commodities, and some are not. Here is what I want to do:

Look at the commodity in column A and compare it to a list of all "NARP" commodities, which I've made on a second worksheet. If the commodity is on that work sheet, I want it to return the word "NARP." If it is not, I want it to return the word "non-NARP."

I've tried the VLOOKUP function [=VLOOKUP(A1,NARP!A1:B33,2)] but it tells me NARP regardless if it is on the list or not. I've left the code in G1; but Avocado is not on the list, so it should not come back as NARP.

My guess from the reading I've done is that I need an IF function, but I have had even less luck with that then the VLOOKUP!

I would greatly appreciate any help on this!

Kikei,

Welcome to the forum!
The function you're looking for is the Countif() function. Using your provided example workbook, in sheet 'Data' cell G1 and copied down would be this formula:

Please Login or Register  to view this content.