VLookup to lookup cell values not formulas?

[GarrettS]

I am trying to do a vlookup to find xyz.123 in another sheet, but the cell containing xyz.123 actually contains the formula =A1&"."&A2 where A1 is xyz and A2 is 123.

Likewise, using the find tool, excel cannot find xyz.123 in the sheet that contains it, unless you choose Options -> Look in: Values instead of Look in: Formulas.

Is there a way to use Vlookup to find xyz.123 in this situation?

Thanks in advance.

 

[MrKowz]

VLOOKUP does look at cells in this fashion. However, I have a sneaking suspicion that your data is quite different from the example. Are you able to give a direct example of the data you are looking up, as well as the expected return?

 

[Sanjeev1976]

Try using Trim function in your formula to get rid of any extra spaces.

Hope this helps.

Sanjeev