Vlookup

[vino3007]

Hi,

Am trying to do a vlookup Sheet1(MIS) A2 with Sheet2 (Working) C2:C5 and return value available in M,N,O,P,Q to Sheet 1 (MIS) at J,K,L,M,N. Since there are some #N/A available in sheet 2(Working) it is returning as #N/A in sheet 1(MIS) also. Please help in solving this issue.

I have attached the sample data for reference.

Warm regards,
Vinoth