Formula based on formula returns N/A

[StuartM1]

Hi all!
Hopefully you can help me with an issue.

Cell 1 has a value based on the result of a formula.
Cell 2 has a formula based on Cell 1, but it return "N/A".

If I just type the value in Cell 1, the formula works.

Any ideas how I should change Cell 1 so Cell 2 shows the correct result instead of "N/A" ?


Thank you very much!!!!

 

[KennyGreens]

What are the formulas in each cell?

 

[StuartM1]

Cell 1 is just a formula to remove an underscore (if one exists) from the value in another cell.
Cell 2 is just a vlookup of whatever is in Cell 1.

Thanks!!!

 

[philwojo]

I would post your exact formulas, but it seems like you might be looking for a numeric value and maybe the formula is providing a text results, so a vlookup would fail on that.

 

[StuartM1]

Thanks very much to you both!!