#REF! error.... for no apparent reason

All,

I am new to this forum but have been using excel for basically forever.

I ran into an error when am using a vlookup inside a vlookup in order to bring information from one place cross-referance it somewhere else and bring me the correct value for the cell.

ok for the details i hope someone can help me.

my code is as follows

=VLOOKUP(VLOOKUP(BK2,main!A3:$CN$5000,main!$Q$2,0),ctrange!$A$1:$C$17,3,0)

Firstly is the code written correctly?

The information is all in the correct columns and tagged correctly, can anyone tell me where my problem is and what i can do to fix it ???

Thanks in advance and have a great day !!!!!!!!

Sorry i wanted to do that... i couldnt figure out how to upload a sample sheet

ooops.... forgot to add those....

here you gotest book1.xlsx

here you go

Hi,
singer.joseph

You hv used cell ref Q2 instead of col index.
second thing nesting in vlookup function executes only when the result matches cell ref;

lts_ram

Its_ram,

I changed the Q2 to q:q to reference the whole column and am still getting the error

Sorry,

In my original sheet there is a numerical value....

Due to sensitivity of information i cant actually post the data

Norie,

In my spreadsheet i have a numeric value, as i posted to Its_ram, due to the nature of the info i cant post it in forums

Thanks for your reply,

i can assure you i havent deleted any cells

and other ideas

Random values in fraction format ie 3/4, 7/8, 1/2, 1 1/3, etc

Ok i played around with it and now i have managed to get to #n/a.... any ideas of what to do now ?

From a table using another vlookup

Oh and yesterday we were upgraded to office 2010... if that makes a difference.

helpful for future use. thanks !!

But didnt help me find the problem now... according to the values it gave me it should work, not give me an n/a value.....

Now its giving me a #N/A

$Q$2 is an integer between 1 and 92....

Sorry for the confusion.....the value in Main$Q$2 is a whole number the values in the rest of the column are fractions

So anyone... any ideas on how to fix it ?

I figured out a temp solution using 6-7 if's but its not ideal....