|Subject:||Re: MATCH, VLOOKUP? How to get T/F Result?|
|Posted by:||Dave Peterson (peters…@verizonXSPAM.net)|
|Date:||Thu, 11 Jan 2007|
will return True or false if A1 is in Sheet2 in column A.
will put in an A or make it look blank.
David Lipetz wrote:
> In one sheet of a multi-sheet workbook, I've got a column of customer
> numbers. In a separate sheet, I've got a column of customer numbers which
> represents a subset of the whole customer list.
> I need to be able to add an alpha code (single letter) in a separate column
> on the first sheet if the customer number on that row is contained in the
> subset list on the second sheet.
> Logically, Excel needs to look at the customer nimber on sheet 1 and try to
> find it on sheet 2. If it does find it, place an "A" in the cell, if it does
> not find it, leave the cell blank.
> I've experimented with VLOOKUP and MATCH, but both return #N/A when the cell
> is not found. I also tried creating an IF statement incorporating ISERROR or
> ISNA, but neither are working for me.
> How should I go about this formula?
MATCH, VLOOKUP? How to get T/F Result? posted by David Lipetz on Thu, 11 Jan 2007