2

So I have two cells, both referring to another sheet. One cell has the row of the other sheet and another has the column.

I tried using an indirect statement along the lines of this: =INDIRECT("'VENDOR COSTING'!R"&R2&"C"&S2) Although I did do a ConvertToLetter so the column letter is F and it is currently in Cell U2. Vendor costing is the other sheet name and the row number is in cell R2.

How can I write an indirect statement to produce the value in that cell on the other sheet?

pnuts
  • 58,317
  • 11
  • 87
  • 139
user3037024
  • 23
  • 1
  • 1
  • 4
  • 3
    I can give you the answer but please show us what have you tried? Questions asking for code must demonstrate a minimal understanding of the problem being solved.Include attempted solutions, why they didn't work, and the expected results. See also: [Stack Overflow question checklist](http://meta.stackexchange.com/questions/156810/stack-overflow-question-checklist) – Siddharth Rout Nov 26 '13 at 15:23
  • I tried using an indirect statement along the lines of this: Indirect("'VENDOR COSTING'!R"&R2&"C"&S2) Although I did do a ConvertToLetter so the column letter is F and it is currently in Cell U2. Vendor costing is the other sheet name and the row number is in cell R2. – user3037024 Nov 26 '13 at 15:28

1 Answers1

6

Please try: 

=INDIRECT("'VENDOR COSTING'!"&U2&R2)

where U2 contains your Column reference and R2 your Row reference.

pnuts
  • 58,317
  • 11
  • 87
  • 139
  • 1
    I had my gym so I couldn't visit earlier but even I would have posted the answer post OP's comment so that is OK :) – Siddharth Rout Nov 26 '13 at 16:43
  • +valid point to answer @pnuts , dont let Sid take all the rep ;p (jk) –  Nov 26 '13 at 16:49
  • @pnuts I think the C# tag is appropriate actually as Excel wouldnt allow to round up to 0.00000000000x etc –  Nov 26 '13 at 16:59