output not coming using vlookup formula

[webmax]

Hi,

I have excel sheet contains master data and output data which has two datas

1) Emp id
2) Emp Name

I put left formula to fetch the emp id and when i try to put the vlookup formula with master data the output is not showing.

But when i change the master data to text format then the output is showing. But i require the solution without changing the text format the vlookup formula output to come.

Attaching the sample sheet for your reference.

Thanks
Webmax

[Gregb11]

It's because the value in your column H is Text, and your value in column A is number. One option is to use this formula instead:

=NUMBERVALUE(LEFT(E3,4))

The other option is to change the values in col A to text.

[TMS]

Use:

Please Login or Register  to view this content.

Or:

Please Login or Register  to view this content.

[TMS]

Or, as Greg says, change the formula in column H.

=LEFT(E3,4)+0
=VALUE(LEFT(E3,4))
=NUMBERVALUE(LEFT(E3,4))