Help in V-Lookup

[nandhamnk]

Hi All,

When iam using vlookup function from one sheet ( say Sheet1 ) and another sheet ( say Sheet2 ) to pick employee Number ,it says as #N/A,since some of the values are in text.Is it possible to change in all the numbers from text to number format

Thanks

[VBA Noob]

Hi,

Can you post an example of the data and the ranges

VBA Noob

[nandhamnk]

Hi,

Thanks for your reply
Please find attached sheet.Though attached sheet works fine,problem persists in office

Thanks

[VBA Noob]

Hi,

No attachment. Plus not sure what you mean by problem persists in office

VBA Noob

[nandhamnk]

Sorry

Here you go

[VBA Noob]

Hi,

Will formatting both list as text work ??

VBA Noob

[VBA Noob]

Or you could try

Using a zero instead of True

=VLOOKUP(A1,B1:D10,2,0)

VBA Noob