Formula Error

[km81 (Km)]

Please help me correcting this formula.

“=IFNA(VLOOKUP(D6,”+SheetNames(0)+“'!D:D,1,0),”+Chr(34)+“Not Applicable”+Chr(34)+“)”

Trying to Lookup value from the first sheet where the sheet name is dynamically change every time

Thanks in advance

[Yoichi]

Hi,

@km81

“=IFNA(VLOOKUP(D6,”+SheetNames(0)+“'!D:D,1,0),”+Chr(34)+“Not Applicable”+Chr(34)+“)”

Can you try to add Single quote as the following?

"=IFNA(VLOOKUP(D6,'"+SheetNames(0)+"'!D:D,1,0),"+Chr(34)+"Not Applicable"+Chr(34)+")"

Regards,