How to make OMR EXIM PAPER in excel ?

[krunal123]

All Question And Answer to save in "Sheet1)

We Need Reference "Question" Sheet1 to Sheet 2 , Also need four Option reference data from Sheet 1 According Question

Kindly make solution this query

 

[mohadin]

Try formulas

C3=VLOOKUP($A$2,Sheet1!$A$1:$F$4,3,0)
C4=VLOOKUP($A$2,Sheet1!$A$1:$F$4,4,0)
E3=VLOOKUP($A2,Sheet1!$A$1:$F$4,5,0)
E4=VLOOKUP($A$2,Sheet1!$A$1:$F$4,6,0)

 

[krunal123]

Try formulas

C3=VLOOKUP($A$2,Sheet1!$A$1:$F$4,3,0)
C4=VLOOKUP($A$2,Sheet1!$A$1:$F$4,4,0)
E3=VLOOKUP($A2,Sheet1!$A$1:$F$4,5,0)
E4=VLOOKUP($A$2,Sheet1!$A$1:$F$4,6,0)

thank you... Sir

 

[mohadin]

You are welcome

 

[krunal123]

You are welcome

but one query running " how to get Question reference to Sheet 1 According Serial number
pleased solve

 

[mohadin]

Sorry

B2=VLOOKUP(A2,Sheet1!A1:F5,2,0)

 

[krunal123]

Sorry

B2=VLOOKUP(A2,Sheet1!A1:F5,2,0)

its Amazing sir...... toooooooooooooo gooooooooooooood

 

[mohadin]

You are very welcome
And thank you for the feedback
Be happy andsafe

 

[smozgur]

its Amazing sir...... toooooooooooooo gooooooooooooood

@krunal123 - please consider marking solution posts for your answered questions to help future readers. You can simply click on the tickmark button right next to the post that answered your question. I did that for this question according to your feedback post as shown below.

More info: Mark as Solution

 

[Fluff]

Duplicate to: How Get Question Reference

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

You have already had one thread locked as a duplicate. In future do NOT start multiple threads for the same question, especially when you have been warned about it.