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?
|