# Excel Formula Help

1. ## Excel Formula Help

Hi Guys,

I am trying to develop a formula which can help me do the following:

1. Looks up for two specific values in two separate columns
2. Looks for the first value in a third column and also looks for the second value in a fourth value
3. If both the first value and second value are found in the same row in the third and fourth columns, then the formula should return TRUE, if not, then it should return FALSE

I've tried to illustrate the example below.

COLUMN 1 COLUMN 2 COLUMN 3 COLUMN 4

10002334 50 10002334 55
10003445 60 10002334 75
10002456 70 10002566 40
10004567 55 10002344 50 (SHOULD MATCH)
10004513 66 10004513 78
10008907 41 10004513 66 (SHOULD MATCH)

I look forward to all of your responses.

2. ## Re: Excel Formula Help

Originally Posted by harvw
Hi Guys,

I am trying to develop a formula which can help me do the following:

1. Looks up for two specific values in two separate columns
2. Looks for the first value in a third column and also looks for the second value in a fourth value
3. If both the first value and second value are found in the same row in the third and fourth columns, then the formula should return TRUE, if not, then it should return FALSE

I've tried to illustrate the example below.

COLUMN 1 COLUMN 2 COLUMN 3 COLUMN 4

10002334 50 10002334 55
10003445 60 10002334 75
10002456 70 10002566 40
10004567 55 10002344 50 (SHOULD MATCH)
10004513 66 10004513 78
10008907 41 10004513 66 (SHOULD MATCH)

I look forward to all of your responses.
Sorry I should have made it clear that the first task of the formula is to look for the first and second values in the same row in COLUMN 1 and COLUMN 2.
It is then looking for these same values in the same row in COLUMNS 3 and 4.

3. ## Re: Excel Formula Help

Maybe this
Enter in E1 and copy down
Formula:
`Please Login or Register  to view this content.`

 v A B C D E 1 10002334 50 10002334 55 2 10003445 60 10002334 75 3 10002456 70 10002566 40 4 10004567 55 10002344 50 Match 5 10004513 66 10004513 78 6 10008907 41 10004513 66 Match

4. ## Re: Excel Formula Help

Originally Posted by AlKey
Maybe this
Enter in E1 and copy down
Formula:
`Please Login or Register  to view this content.`

 v A B C D E 1 10002334 50 10002334 55 2 10003445 60 10002334 75 3 10002456 70 10002566 40 4 10004567 55 10002344 50 Match 5 10004513 66 10004513 78 6 10008907 41 10004513 66 Match
Thanks. The formula works like a treat!

Out of interest, if I wanted to do this for multiple columns, i.e. look for eight different values in the same row (C1, C2, C3, C4, C5, C6, C7 C8) and then find exactly the same values in eight different columns (C9, C10, C11, C12, C13, C14, C15, C16) what would the structure of this formula look like?

There are currently 1 users browsing this thread. (0 members and 1 guests)