Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
logical formula | Excel Worksheet Functions | |||
Help with Logical Formula | Excel Worksheet Functions | |||
Need help about logical formula | Excel Worksheet Functions | |||
Logical formula with dates | Excel Worksheet Functions | |||
Logical Text Formula | Excel Worksheet Functions |