# Multi IF conditions query

#### dessim

##### New Member
Hi, I have this issue here, Basically, I need to compare data btw List1 against List 2, and if match; List 3 info will appear on the Result column

Example A123 (List 1) matches A123 (List 2) the info on List 3 = Office A. Office A will auto appear on the Result column

Am I supposed to use the IF multi-condition formula?

Thank you so much folks
 List 1 List 2 List 3 Result A123 B123 Office B Office A B123 C456 Office C C456 A123 Office A

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Is this what you mean?

22 01 21.xlsm
ABCD
1List 1List 2List 3Result
2A123B123Office BOffice A
3B123C456Office COffice B
4C456A123Office AOffice C
Lookup
Cell Formulas
RangeFormula
D2:D4D2=VLOOKUP(A2,B\$2:C\$4,2,0)

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Is this what you mean?

22 01 21.xlsm
ABCD
1List 1List 2List 3Result
2A123B123Office BOffice A
3B123C456Office COffice B
4C456A123Office AOffice C
Lookup
Cell Formulas
RangeFormula
D2:D4D2=VLOOKUP(A2,B\$2:C\$4,2,0)
oh yes. thank you very much.
Hv updated accounts details too.
have a good day!

You're welcome.

.. and thanks for updating your details.

Replies
1
Views
97
Replies
0
Views
58
Replies
3
Views
138
Replies
8
Views
430
Replies
10
Views
174

1,203,171
Messages
6,053,874
Members
444,692
Latest member
Queendom

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back