Extending a V-Lookup

[Excel_77]

Hi All,

Can I expand the following formula that if the value in A2 is not found within the "Data" tab that the word "Empty" is returned?

=(VLOOKUP(A2,Data!A1:C887,3,FALSE))

 

[MrKowz]

If the value is not found, it will return an #N/A error, which we can catch by wrapping the formula with IFERROR:

=IFERROR(VLOOKUP(A2,Data!A1:C887,3,FALSE),"Empty")

 

[Jonmo1]

Try IFERROR

=IFERROR(VLOOKUP(A2,Data!A1:C887,3,FALSE),"Empty")

 

[Excel_77]

That has not quite worked, let me put a different outcome, is this possible?

=(VLOOKUP(A2,Data!A1:C887,3,FALSE),"Empty")

Look for the value in A2 within the Data tab, if it's there return true otherwise return empty.

 

[MrKowz]

If I understand correctly, you want to look up the value A2 in the Data tab. If the value is found, you want the formula to return "TRUE". If the value is not found, you want to return "Empty".

Is this accurate?

 

[Jonmo1]

So it's no longer a vlookup. You're just verifying the existance of the value.

Try

=IF(COUNTIF(Data!A1:C887,A2),TRUE,"")