Problem - Lookup returning value of last cell in range when no matchoccurs
 

(LOOKUP(P14,'Structures 01'!$G:$G,'Structures 01'!$C:$C)

If a matching value is found it returns the correct value from column
C, if no match is found it seems to return the value of the last cell
in column C. I need it to return N/A, false error etc, rather than
something that could be taken for a valid lookup. This only occurs
with certain sets of data.

Ultimately I want to use a macro to populate the required cells with
the above Lookup.

I've spent ages trying to resolve it but can't figure it out, any help
or pointers would be gratefully received.

Thanks
Ritchi

Problem - Lookup returning value of last cell in range when nomatch occurs
 

Hello Ritchie,

Maybe vlookup with the additional (last) parameter 0 (False) will help
you.

Regards,
Bernd

Problem - Lookup returning value of last cell in range when nomatch occurs
 

Tried VLOOKUP but the same problem occurs

Thanks
Ritchi

Problem - Lookup returning value of last cell in range when nomatch occurs
 

Bernd

Apologies now I've added the last parameter it seems to work.
Many Thanks
Ritchi