Axolot Data

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

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.