Hi
I have seen a vlookup within one spreadsheet that if there not a value then it is left blank although the formulae appear to be the same
=VLOOKUP(@$A:$A,CountryLookup!$A:$J,8,FALSE)
Yet when I use my spreadsheet the response is 0
=VLOOKUP(@$A:$A,CountryLookup!$A:$J,8,FALSE)
How can I get the first result please
Thank you
I have seen a vlookup within one spreadsheet that if there not a value then it is left blank although the formulae appear to be the same
=VLOOKUP(@$A:$A,CountryLookup!$A:$J,8,FALSE)
Yet when I use my spreadsheet the response is 0
=VLOOKUP(@$A:$A,CountryLookup!$A:$J,8,FALSE)
How can I get the first result please
Thank you