eval of concatenate function not displaying results

T

tony12345

I am attempting to evaluate a text string (concatenation of an index/match
text string of an external file). The function results in the cell displaying
#REF!, but when clicking on the fx (function arguments dialog box), the
"Formula Result=" evaluates out correctly to the text string I was attempting
to lookup in the external file.

removing the "=" sign, changing cell formating to "General" and using All
caps doesn't work. nor does using the "indirect" function

Copying and pasting the restult of the concatenation (a text string) into
another cell and pressing return evaluates the string properly. and the eval
function evaluates the function properly but simply won't display it.
 

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

Using INDIRECT Function and INDEX Function 1
Concatenate function not working for me 2
Variations on referencing a cell in another workbook - continued 4
Problem with Concatenate Function 5
VBA Function to evaluate hlookup text string as formula 2
Concatenate Function 6
Is there a function that will evaluate a text string in a cell? 2
evaluate a concatenate expression 3

Top