Multi IF conditions query

[dessim]

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

Can someone advise how could I achieve that please?

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

 

[Peter_SSs]

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
	A	B	C	D
1	List 1	List 2	List 3	Result
2	A123	B123	Office B	Office A
3	B123	C456	Office C	Office B
4	C456	A123	Office A	Office C
Lookup

Cell Formulas
Range	Formula
D2:D4	D2	=VLOOKUP(A2,B$2:C$4,2,0)

 

[dessim]

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
	A	B	C	D
1	List 1	List 2	List 3	Result
2	A123	B123	Office B	Office A
3	B123	C456	Office C	Office B
4	C456	A123	Office A	Office C
Lookup

Cell Formulas
Range	Formula
D2:D4	D2	=VLOOKUP(A2,B$2:C$4,2,0)

oh yes. thank you very much.
Hv updated accounts details too.
have a good day!

 

[Peter_SSs]

You're welcome.

.. and thanks for updating your details.