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

R

RITCHI

(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
 
B

Bernd P

Hello Ritchie,

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

Regards,
Bernd
 
R

RAB

Bernd

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking up a Cell and returning correspong Cell value 0
Copy row info but not in normal column sequence 6
Find matching cell and return value of a different cell 5
Select value on a cell by matching value of two cells 1
Lookup for a value in a table 2
Save user entered value in hidden lookup table. 4
Populating values in cells based on lookup from other cell. 4
Lookup against concatenated source value 4

Top