Can anyone possibly help with the following?
I have the formula below which keeps returning #N/A

VLOOKUP(TRIM($A4),’Worksheet Name'!A261:D261,3,FALSE)

Where the value to be found in the Range is in B261 (column 2) and the
value I want returned is in C261 (column 3) which is the letter “R”.

When I evaluate the formula using F9 I get the following:

=VLOOKUP("5-C60-0019"),{0,"5-C60-0019","R",0},3,FALSE)

I am only checking row 261 as I know the number exists in my table and
the formula should work and then I will use it across the whole table
range. I am so close to getting this to work.

Can anyone advise on why this curled arrow evaluation is happening?
{0,"5-C60-0019","R",0} and if this is the cause of my formula not
working.

Thanks in advance for any input!

LCTECH