On sheet2, i have put vlookup function to get the option price from sheet1. Whenever i try to find the CALL price its gives me N/A as result and gives proper result for PUT price. Kindly help.
On sheet2, i have put vlookup function to get the option price from sheet1. Whenever i try to find the CALL price its gives me N/A as result and gives proper result for PUT price. Kindly help.
Last edited by ankit_85; 09-11-2010 at 01:28 AM.
The value you're looking for (5100) isn't in column "C", it is in column "J" however. VLOOKUP will only search in the leftmost column.
Cheers,
Last edited by ConneXionLost; 09-11-2010 at 01:10 AM.
Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
So wat can be done to get the correct answer?
Try INDEX & MATCH instead:
Cheers,Please Login or Register to view this content.
Thanks a lot...!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks