Left Lookup Help

[djlw84]

Hi

I am trying to do a left lookup between two workbooks (both stored on OneDrive for Business), however, when using the Index/Match functionality, it is returning a N/A.

I need the formula in Column K of 'UBWO Test' to lookup the value in Column A (UBWO ID) of 'UBWO Test' in the 'Pipeline Test' workbook (value will be in Column C (UBWO ID Number) and return the value in Column A (Pipeline Request ID) of 'Pipeline Test' workbook...

Happy to share the workbooks with anyone who is able to help....

 

[earthworm]

Index Match function also works . Since you are asking for Vlookup here it is

Book1
	A	B	C	D	E
1	B1	A1
2	A	1		A1	B1
3	B	2		2	B
4	C	3
5	D	4
6	E	5
Sheet1

Cell Formulas
Range	Formula
E3	E3	=VLOOKUP(D3,CHOOSE({1,2},$B$2:$B$6,$A$2:$A$6),2,0)

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Left Lookup Help
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.