Search Excel form (Formula?)
 

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?

Thanks

Search Excel form (Formula?)
 

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.

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.

Search Excel form (Formula?)
 

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.

Search Excel form (Formula?)
 

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.

Search Excel form (Formula?)
 

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.