How do I match the cell number in Excel spreadsheet

I have a spreadsheet 1 column A with some numbers and sheet 2 column B with cell numbers of A in column B. I need a formula to automatically retrieve the corresponding value of cell numbers of B in A of sheet 1 and put it in Column C of sheet 2. I have attached the spreadsheet
Excel-formula.xls
jpeterjeyarajAsked:
Who is Participating?
 
zorvek (Kevin Jones)ConsultantCommented:
Well, I'm taking a guess since the question is vague and the sample data lacking.

See attached.

Kevin
Excel-formula.xls
0
 
barry houdiniCommented:
I'm not clear on your requirement - it seems that you want a formula in C2:C5 in sheet2, what results do you expect for your example?

regards, barry
0
 
ssisworoCommented:
like this ?

 Excel-formula.xls
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
ssisworoCommented:
here the preview...

 preview
0
 
jpeterjeyarajAuthor Commented:
Sorry for the confusion, this what I need - the column C in the attached spreadsheet, I need the values of A in sheet1 based on B, the value of B is nothing but the cell n umber belongs to A. For eg in the column B3, the value 3 reflects the cell number A 3 in sheet 1, the output in column should be corresponding value of A3 which is 22 and so forth. I have attached the spreadsheet.
Excel-formula.xls
0
 
zorvek (Kevin Jones)ConsultantCommented:
Got it.

Kevin
Excel-formula-3-.xls
0
 
zorvek (Kevin Jones)ConsultantCommented:
To show NA for blank cells as well as cells with 0 use:

   =IF(OR(A2=0,A2=""),NA(),INDEX(Sheet1!A:A,A2))

Kevin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.