How to use vlookup on the output value of a formula?

[vijitkumar]

Sheet1: C2 value is output of a formula to concatenate A2 and B2 cell values.

I am trying to use Vlookup and lookup C2 in Master data sheet.


Again in Master Data sheet, A2 cell value is output of a formula.

Below is the formula I am trying to use.

=VLOOKUP(C2,'Master data'!A:D,4,FALSE)

I understand that the issue is that C2 value in Sheet1 and A2 value in Master data are not string and hence the issue is happening.

Please let me know what is the best work around to address the issue. I would like to solution to be dynamic and not a manual copy and paste special value option.

 

[vletm]

vijitkumar
Both sheets have to have same values...
... there is one extra space between Java and 2