How to Make a Row Return Column Values

[rentb23]

Hello,

I am trying to make a row return column values in another sheet. I currently have this formula in row K10: =IF($D$14="Yes",'Sheet 2'!G27,0)
The next formula in row L10 should be something like =IF($D$14="Yes",'Sheet 2'!G28,0)
I want to fill down to make row 10 return values in column G, how can i do that?

Thanks

[Jacc]

Put this in K10 and copy right. That will give you from G27 to G37. Modify to suit your needs.

Please Login or Register  to view this content.