VLOOKUP referring to another workbook

[AllanGMorris]

Hi,

I am trying to perform a VLookup referring to another workbook and getting uknown sheet name

The lookup contents is VLOOKUP(B4,"[MAPPING.xlsx]"MAP!$N$2:$O$52,2,FALSE)

It doesn't seem to recognise the sheet MAP but it is definately there? Is my lookup definition incorrect?

Thanks
Allan

[larsa]

Hello

The syntax may be wrong. Create an excel sheet (in Excel) that contains the formula you want. Then, read the formula with the component to check the syntax.