Match two cells returning data from third cell

[Christopherdj]

Hi all
I've been trying to find a quick solution to this with no avail.
Wonder if someone can assist. I have 2 sheets, want to match data in columns B and C of Export sheet with Columns A and B of Lookup sheet, with the matched result being the data from Column C of Lookup into column A of the export sheets.
Small sample provided, my database has around 500 entries and am thinking a vlookup/match query?
Thanks in advance for any help you can provide.

[bebo021999]

Try:

Please Login or Register  to view this content.

[alansidman]

Result as below. Brought each table into Power Query. Joined tables with outer join

Excel 2016 (Windows) 32 bit

	E	F	G
1	Heading 1	Heading 2	Export.Heading 1
2	ghi	CD	1234A
3	def	AB	6543F
4	stu	KL	8765R
5	jkl	EF	987U
6	mno	GH	57648Z
7	pqr	IJ	982L

Sheet: Lookup

Mcode for join

Please Login or Register  to view this content.

Review PQ
In the attached file
Click on any cell in the new table
On the Data Tab, click on Queries & Connections
In the right window, double click to open Query
Review PQ steps

M-code basics:
- "let" is the start of a query
- "in" is the closing of a query
- each transformation step sits in between those 2 lines
- each step line is ended by a comma, except the last one
- "Source" is always the first step (Source Data)
- After "in" you have the last step referenced

[Christopherdj]

OH WOW, thanks for the quick solution/s to you both. Solves my problem on both solutions. Thank you so very much.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[Christopherdj]

Oops, closed it off too soon.
bebo021999 your formula worked fine in the example sheet, however when I add to my actual, all I get is #N/A result.
If you change the sheet "Lookup" to "DATA", it may help me to understand, using the word lookup has made the code a little confusing.

I also don't want it restricted to rows 2 and 7 only, so I know I can amend it to $A:$A etc. but there is an issue I can't seem to fix.
As stipulated in my original post, there are over 500 entries to try to match.

[Christopherdj]

My apologies once again, it seems when a result is #N/A it usually means there is something wrong with the data source. I woke during the night with the issue - it was with my data between the two sheets. I can modify your result to meet my needs, now solving this and again my sincere apologies for any confusion - it was my error not yours.