Search Excel form (Formula?)

Ok, I did look at this option but needed a little help with how and where to
put the command to get the out put I need.

Highlight I think I have covered.


Thanks

"smartin" wrote:

> Rob I wrote:
> > I have two worksheets in excel 2003 and I want to check if there are any
> > matches from column C on worksheet to with worksheet ons column F. They are
> > numbers and leters that I need to match up if any and then highlight. What is
> > the best formula to use or way to complete this?
>
> For matching, check into VLOOKUP. Perfect for matching one column
> against another.
>
> For highlighting, perhaps conditional formatting will do the trick.
>

So assume Column C has the "foundation" information and Column "F" has
some input you are hoping to match in C.

In a spare column, try this:

=VLOOKUP(F1,C:C,1,FALSE)

This can be filled down in your spare column.

This will check if F1 is somewhere in Column C. If it is, the value in
Column C is returned. If not, #N/A is returned.

Does this help?


Rob I wrote:
> Ok, I did look at this option but needed a little help with how and where to
> put the command to get the out put I need.
>
> Highlight I think I have covered.
>
>
> Thanks
>
> "smartin" wrote:
>
>> Rob I wrote:
>>> I have two worksheets in excel 2003 and I want to check if there are any
>>> matches from column C on worksheet to with worksheet ons column F. They are
>>> numbers and leters that I need to match up if any and then highlight. What is
>>> the best formula to use or way to complete this?
>> For matching, check into VLOOKUP. Perfect for matching one column
>> against another.
>>
>> For highlighting, perhaps conditional formatting will do the trick.
>>

I think so. What I have is this Column A "200 items" and Column B "840 items"
of alphanumeric information and I need to cross check them to see if any
matches are found from Column A to Column B. So I would put the Vlookup in
Column C from cell 2 through 840 then it would let me know if any matches
were found?

"smartin" wrote:

> So assume Column C has the "foundation" information and Column "F" has
> some input you are hoping to match in C.
>
> In a spare column, try this:
>
> =VLOOKUP(F1,C:C,1,FALSE)
>
> This can be filled down in your spare column.
>
> This will check if F1 is somewhere in Column C. If it is, the value in
> Column C is returned. If not, #N/A is returned.
>
> Does this help?
>
>
> Rob I wrote:
> > Ok, I did look at this option but needed a little help with how and where to
> > put the command to get the out put I need.
> >
> > Highlight I think I have covered.
> >
> >
> > Thanks
> >
> > "smartin" wrote:
> >
> >> Rob I wrote:
> >>> I have two worksheets in excel 2003 and I want to check if there are any
> >>> matches from column C on worksheet to with worksheet ons column F. They are
> >>> numbers and leters that I need to match up if any and then highlight. What is
> >>> the best formula to use or way to complete this?
> >> For matching, check into VLOOKUP. Perfect for matching one column
> >> against another.
> >>
> >> For highlighting, perhaps conditional formatting will do the trick.
> >>
>

If you need to know if entry A is somewhere B, then

=VLOOKUP(A2,B:B,1,false)
(fill through row 201 for 200 items in A)


Conversely, if you need to know if entry B is somewhere in A (I think
this is the one you want):

=VLOOKUP(B2,A:A,1,false)
(fill through row 841 for 840 items in B)


In both cases, either a matching value is returned, or #N/A if no match.


Rob I wrote:
> I think so. What I have is this Column A "200 items" and Column B "840 items"
> of alphanumeric information and I need to cross check them to see if any
> matches are found from Column A to Column B. So I would put the Vlookup in
> Column C from cell 2 through 840 then it would let me know if any matches
> were found?
>
> "smartin" wrote:
>
>> So assume Column C has the "foundation" information and Column "F" has
>> some input you are hoping to match in C.
>>
>> In a spare column, try this:
>>
>> =VLOOKUP(F1,C:C,1,FALSE)
>>
>> This can be filled down in your spare column.
>>
>> This will check if F1 is somewhere in Column C. If it is, the value in
>> Column C is returned. If not, #N/A is returned.
>>
>> Does this help?
>>
>>
>> Rob I wrote:
>>> Ok, I did look at this option but needed a little help with how and where to
>>> put the command to get the out put I need.
>>>
>>> Highlight I think I have covered.
>>>
>>>
>>> Thanks
>>>
>>> "smartin" wrote:
>>>
>>>> Rob I wrote:
>>>>> I have two worksheets in excel 2003 and I want to check if there are any
>>>>> matches from column C on worksheet to with worksheet ons column F. They are
>>>>> numbers and leters that I need to match up if any and then highlight. What is
>>>>> the best formula to use or way to complete this?
>>>> For matching, check into VLOOKUP. Perfect for matching one column
>>>> against another.
>>>>
>>>> For highlighting, perhaps conditional formatting will do the trick.
>>>>