Returning a value from another sheet

[lovleigh]

I would like a formula that will look in cell R1 of sheet "board uninsured" and based on the number in that cell, look at a specific cell on another sheet and return to value in G12 of "board uninsured". R1 will contain a number corresponding to the month. For instance, 1 is January, 2 is February etc. If the number is 1, I need the formula to look at the "combined" sheet cell E115 for the data to populate in cell G12 of "board uninsured". If cell R1 contains a 2 I need it to look at cell F115 on "combined" and populate that data into G12 of "board uninsured". And so on.

Thank you in advance

 

[venomxx6]

Here is one solution. I created a sheet based on your description. I think this will do what you want. (it's not fancy) This formula would go in "board uninsured" cell G12 =IF(R1=1,combined!E115,IF(R1=2,combined!E116,IF(R1=3,combined!E117,IF(R1=4,combined!E118,IF(R1=5,combined!E119,IF(R1=6,combined!E120,IF(R1=7,combined!E121,IF(R1=8,combined!E122,IF(R1=9,combined!E123,IF(R1=10,combined!E124,IF(R1=11,combined!E125,IF(R1=12,combined!E126,""))))))))))))

 

[Paella1]

Populate the range E114:P114 on the combined sheet with the numbers 1 to 12. Then in board uninsured cell G12 put the formula =HLOOKUP(R1,combined!$E$114:$P$115,2,FALSE).

If you can't put 1 to 12 in Row 114, use another row, but make sure it is above Row 115. Then you will need to amend the third argument in your HLOOKUP formula. For example, if you put 1 to 12 in Row 110, the formula becomes =HLOOKUP(R1,combined!$E$114:$P$115,6,FALSE).

Whichever row you put your 1 to 12 in, you might like to hide it. The formula will still work.