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
Bookmarks