Hi guys,

Does anyone know why the following formula doesn't work as an array formula?:

VLOOKUP(D15:D195,B15:B195&"_client",2,FALSE)


I highlight cells S15:S195, enter the above formula in the formula pane, and press Ctrl+Shift+Enter and I get a #N/A error.

Thanks

Manumusashi