Hi,
I am hoping someone can help me. I have the following formula inputted in Sheet 1 in cell A3:
=INDEX(Sheet2!$B2:DJ2,MATCH($A$2,Sheet2!$B$1:$DJ$1,0))
It basically states that if the drop down list in A2 matches with any cell in Row1 in Sheet 2 then it will drag through whatever is below that cell in Sheet 2 in to A3.
Either way the problem I have is that when the formula drags through the result into cell A3 I need to be in a "Paste Values" format, so basically no formula.
Is there a way that the formula above could drag through the result from Sheet 2 into Sheet 1 but not as a formula as a "Paste Value".
Thanks in advance, it is greatly appreciated.
I am hoping someone can help me. I have the following formula inputted in Sheet 1 in cell A3:
=INDEX(Sheet2!$B2:DJ2,MATCH($A$2,Sheet2!$B$1:$DJ$1,0))
It basically states that if the drop down list in A2 matches with any cell in Row1 in Sheet 2 then it will drag through whatever is below that cell in Sheet 2 in to A3.
Either way the problem I have is that when the formula drags through the result into cell A3 I need to be in a "Paste Values" format, so basically no formula.
Is there a way that the formula above could drag through the result from Sheet 2 into Sheet 1 but not as a formula as a "Paste Value".
Thanks in advance, it is greatly appreciated.