Hello

I have searched many times on google to solve this problem and was unable to find what i am looking for.

I have 2 Sheets of data, and at certain point one cell dependes on the result of another.

The first one is:

=IF( INPUT!$P24=0;"";INPUT!$P2)
With result:
ADOLFO MANUEL GONCALVES DA SILVA

Then... i want the result above, and do a VlookUP and search for another information, in this case de ID number of the coWorker.

The table i use has exactly the same information but instead there is an error.
I wont give you the error as i know its not the formula.

One other thing-
When i wan to use the result as NUMBER, i put "+0".
How do i use the result as TEXT?
I have tryed "+TEXT", "&TEXT". I dont know what to do.

Thank you
Best Regards