vlookup

[jass81]

I have a data's in sheet 1. in sheet 2,3 and 4 there is some ref nos. if that ref nos matching sheet1 that entire row to be copied that concern sheet. I used vlookup here if that value is no matching that cell shows #N/A how to solve this issue. Is there any other way please tell me.

Thanks in advance..

 

[Somendra Misra]

Hi jass81....

it seems you have not locked the reference of lookup range in formula. Try changing lookup range from relative reference to absolute reference.

Regards!

 

[SirJB7]

Hi, jass81!

Welcome!

As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

Regards!

 

[Chandrashekar.A]

Hi jass81!,

Use absolute cell reference method, then you will get the correct result.

for more information please refer below mentioned link.

http://web.pdx.edu/~stipakb/CellRefs.htm

 

[NARAYANK991]

Hi ,

Check your file ; I have put in the formulae on one sheet ; you can do the same for the other tabs.

Narayan