Problem with Vlookup - have value in sheet but show error #N/A

hi frends,

I had searched forum and can't get my answer.. may be i can't get that thread.. today is sunday and i am in office, and have lots of work and pressure, i have to show data to my boss tomorrow

Thats why i am starting this thread... sorry

I am facing problem with vlookup
i have a good hand on vlookup..
but don't know what happened....

Problem
there is two sheets/workbook both sheets/workbook contains same value
but don't know why the error showing #N/A... when i continue with same formula.. its comes corectly
i mean i have to do 7 - 8 times vlookup

Example
sheet contains 100 row
1st time i get result of 20 rows
2nd time i get result of 10 rows
3rd time i get result of 10 rows
and go on.....

everytime i am sorting column and doing vlookup

what is the problem frends ?

pls help me..

Thanx

you plz upload a sample of your workbooks...i or somebodyelse will surely help

Thanks Rohan for your reply...

Attached is a test sheet....

In Sheet1 in column D and F and i want value from sheet2

Thanx

Thanks for your reply frend

Yes its work now....

i have to select whole column for getting value...

but frend sometimes its shows error (not rememeber exactly) Error : there is enough range 256 -something like this
thats why i vlookup in rows not in column - i hope u get what i am trying to say...

Hi

The reason why the VLook Up function is giving you a number of incorrect results is because you have not applied the 'absolute cell references' (ie: inserting the dollar signs to the cell ranges) to your cell ranges. As you'll see from the attached file (columns H and I), I have done this for you. I have also come across six codes listed in sheet 1 that are not included in sheet 2. This explains why the VLook Up function is unable to locate them. To view these, you'll need to filter for "Code not found in Sheet 2" in the column header for columns H and I.

I hope your boss won't give you any grief tomorrow.

Hope this helps.

Peter

Here's Your Solution:
just Replace Your Formula In D2 with : =VLOOKUP(A2,Sheet2!$A$2:$C$263,3,0)
And In F2 With : =VLOOKUP(A2,Sheet2!$A$2:$D$263,4,0)
and Drag it down to all cells