vlookup help

[Nabeel]

gud day all
plz find attached..here i want i drag vlookup formula rite to left the num will be changed automatically...i have lock the look up value and selective range..with this when drag whole formula to top to lower data comes same...want to only one formula to drag rite to left chnage num automatically and top to lower to get req data.....BR

 

[NARAYANK991]

Hi ,

Something like this ?

Narayan

 

[Nabeel]

hi too
almost....horizontally its ok...but vertically coming same data.....want to use only one formula for both horizontal and vertical dragging....BR

 

[Nabeel]

its ok,its working....thnx a lot...