Logical formula from a list
 

I have a list of approved vendors (vendor numbers) on sheet 2. On sheet 1, I
need Excel to look at A1 to see if that vendor number is in the list of
approved numbers on sheet 2 and return true or false. How can I tell it to
look in the list of approx. 115 vendors to see if the number is approved?

Logical formula from a list
 

Use COUNTIF():

Assuming the list is in column A on Sheet2:

=IF(COUNTIF(Sheet2!A:A,Sheet1!A1)0,"On the list","Not on the list")

--
Gary''s Student - gsnu200811


"charlie" wrote:

I have a list of approved vendors (vendor numbers) on sheet 2. On sheet 1, I
need Excel to look at A1 to see if that vendor number is in the list of
approved numbers on sheet 2 and return true or false. How can I tell it to
look in the list of approx. 115 vendors to see if the number is approved?

Logical formula from a list
 

See VLOOKUP in the excel help files.

"charlie" wrote:

I have a list of approved vendors (vendor numbers) on sheet 2. On sheet 1, I
need Excel to look at A1 to see if that vendor number is in the list of
approved numbers on sheet 2 and return true or false. How can I tell it to
look in the list of approx. 115 vendors to see if the number is approved?

Logical formula from a list
 

THANK YOU, THANK YOU, THANK YOU! That makes my job SOOOO much easier...

"Gary''s Student" wrote:

Use COUNTIF():

Assuming the list is in column A on Sheet2:

=IF(COUNTIF(Sheet2!A:A,Sheet1!A1)0,"On the list","Not on the list")

--
Gary''s Student - gsnu200811


"charlie" wrote:

I have a list of approved vendors (vendor numbers) on sheet 2. On sheet 1, I
need Excel to look at A1 to see if that vendor number is in the list of
approved numbers on sheet 2 and return true or false. How can I tell it to
look in the list of approx. 115 vendors to see if the number is approved?

Logical formula from a list
 

Charlie,
Disregard my previous post. I was thinking of a different scenario. Sorry.

"CRS" wrote:

See VLOOKUP in the excel help files.

"charlie" wrote:

I have a list of approved vendors (vendor numbers) on sheet 2. On sheet 1, I
need Excel to look at A1 to see if that vendor number is in the list of
approved numbers on sheet 2 and return true or false. How can I tell it to
look in the list of approx. 115 vendors to see if the number is approved?