Tyring to do an IF function but am getting a circular reference error. Not sure if you use this function and could possibly help?

Circular reference means you are including the result of a formula in the calculation. You will need to post specifics in order for me to help you. Information such as the data you have and what you are trying to do is needed.

Can i extract a data by lookup using 2 column data?it not match a single column data, but i need it to match a complex 2 or more column data

You can try using SUM(IF()). http://support.microsoft.com/kb/275165

Dear, I have a Excel Sheet of about 500 questions from different subjects. As my job need, i have to take the exams of the trainees here. I want the excel Sheet that can generate random questions from the list. The full description is, I have a spreadsheet with questions. Every question has four options, option A, Option B, Option C, Option D. The trainee need to select from the list proveded as From Option A to Option D. No need to use keyboard. Only select from the List. My main problem is i am not able to sort it randomly. Right now i am doing it mannually. I am getting the results ready as the trainee clicks on the Finish Button but not the random generation. Please help me. my mail id is mangeshmalvankar[at]gmail.com

RE: Mangesh

I might not understanding correctly ... but If you want to sort randomly how about you add a column to the spreadsheet and put the formula rand() for each row in that column. The rand function will insert a random number which constantly changes into the cell. Now you can sort by the column and you will have unique order everytime.

Dear Sir, Thanks for replying. Please understand. I am handelling a exam. The exam paper contains 20 questions on each subject. A question has four options Option A, Option B, Option C and Option D. Another Sheet contains about 500 questions. In one row, Question, Option A, Option B, Option C, Option D, Correct Answer, Trainees Answer, Justification. These are different columns in that row. means 1 row contains one question. another row has another question. In this way i have to ask 20 questions on each subject. But the questions must be in the randomly generated fashion. each question must be unique for that test.
Right now i am doing manually. but i am getting the results ready when the trainee clicks on finish. All the result sheets are updated in my laptop eachtime. for this i am using the MAP DRIVE option successfully. But a much problem with Random generation. Hope you understand the program. Please guide me. i am regularly viewing your site. but not getting the proper answer. my mail id is mangeshmalvankar[at]gmail.com.