T
Timmy Mac
Hello everyone...my first post on what looks to be a very informativ
and helpful forum.
What led me to find it was the following problem which is causing me
lot of frustration.
I am "interrogating" certain data and want return connected data if th
cell contains a value in the lookup table but return 0 if there is n
look up value.
Rather than do this using the iIF and ISNA functions, I have use
COUNTIF to determine whether the value exists in the first column of m
lookup data and if the result is greater than zero, return a
appropriate lookup value.
However I am finding that some data is recognised by the COUNTI
function and returns a value greater than zero, the VLOOKUP functio
does not recognise the same data.
If I compare the data from the two cells (the one on which I'
performing the lookup and the one in the table, they are of simila
TYPE() and the EXACT() function returns TRUE and a simple paste fro
one to the other gets the VLOOKUP working, but there is a lot of dat
and recalculating takes a long time.
any ideas anyone
and helpful forum.
What led me to find it was the following problem which is causing me
lot of frustration.
I am "interrogating" certain data and want return connected data if th
cell contains a value in the lookup table but return 0 if there is n
look up value.
Rather than do this using the iIF and ISNA functions, I have use
COUNTIF to determine whether the value exists in the first column of m
lookup data and if the result is greater than zero, return a
appropriate lookup value.
However I am finding that some data is recognised by the COUNTI
function and returns a value greater than zero, the VLOOKUP functio
does not recognise the same data.
If I compare the data from the two cells (the one on which I'
performing the lookup and the one in the table, they are of simila
TYPE() and the EXACT() function returns TRUE and a simple paste fro
one to the other gets the VLOOKUP working, but there is a lot of dat
and recalculating takes a long time.
any ideas anyone