Vlookup from different spreadsheets based on information in cell

[Ekoor]

Hi

This is my formula:

=IFERROR(IFERROR(IFERROR(IFERROR (VLOOKUP(c9,’ V:\PPHL\==Loan Maintenance==\Allocations\2017\August\E Koor\[Cashbook1.xlsx]'!$A$1:$k$100,9,FALSE),VLOOKUP(c9,’V:\PPHL\==Loan Maintenance==\Allocations\2017\August\D Makhubu\[CASHBOOK FOR AUGUST 2017.xlsx}'!$A$1:$k$100,9,FALSE), ,VLOOKUP(c9,’V:\PPHL\==Loan Maintenance==\Allocations\2017\August\N Buthelezi\[August Cash Book.xlsx}'!$A$1:$k$100,9,FALSE), ,VLOOKUP(c9,’V:\PPHL\==Loan Maintenance==\Allocations\2017\August\Tebogo Tshetlo\[CASHBOOK.xlsx}'!$A$1:$k$100,9,FALSE)),"")

But, the == in location name is throwing me off.

 

[BerndKuerzinger]

If I may ask: What is your question?

Regards,
Bernd

 

[Ekoor]

If I may ask: What is your question?

Regards,
Bernd

How do I tell excel that == is not equls to but a part the file location name?

 

[Ekoor]

Still havent figure this one out.

Any help will be appreciated?

 

[BerndKuerzinger]

Ekoor,

I don't think it's feasible, it's seems to be an issue in Excel parsing that can't be "worked around" without changing the = signs in the files paths. That said it's impossible to prove a negative, so I'd be happy to be proven wrong.

Kind regards,
Bernd