Excel 2007 : Using Formula result as TEXT for other formulas.

Perhaps you are saying you want something like:

=IF(INPUT!$P24=0;"";VLOOKUP(INPUT!$P2;'anothersheet'!$A:$B;2;0))

In terms of how you coerce a number to a string, use &"", eg: =(1*2)&""

Hi

Will this help? Please open the files i uploaded.

The first is the formula to get the name of the tecnician.
The second finds the ID based on the name.

The name is exactly the same but it cant find the ID, wish is in the first collumn i use in the second print screen.

This must be this way because... well maybe not.
I´ll try doing in reverse.

Images are of limited use in truth.

We can tell from the Image that the VLOOKUP is failing to find a match but we have no idea if the names are actually listed in INPUT!O:O

(note: your table array contains 2 coumns [O:P] yet presently you're returning column 1 - this doesn't affect the current Error but is something you should be aware of)

by all means upload your file - I am going off line for a while but rest assured others will be able to resolve for you

Thank you so much.

Ok so here it is:

I need to remove all the duplicated IDs From "ID Técnicos" to the column "Remove Duplicate".

And then i would like to use the ID to search for the name of the coworker.
I hope i can do the rest.

But removing automaticly duplicat records and search with vLookup using the TEXT result of another Formula is making me headheaks.

Thank You
Best Regards

Perhaps you could outline the first few expected results (calculated manually) ?

As far as I can tell every ID in your list is a duplicate... on that basis I'm not quite sure what you're looking for in terms of end result.

If you are saying you wish to create a unique listing from your parent list then perhaps:

B3:
=IF(OR($B2="";$B2=0);"";LARGE($A$3:$A$25000;1+COUNTIF($A$3:$A$25000;">="&$B2)))
copied down to B200

C3:
=IF(SUM($B3)=0;"";VLOOKUP($B3&"";INPUT!$O:$P;2;0))
copied down to C200