=index('order numbers'!e:e,a1)
where a1 contained that number

or with minor validity:

=if(a1="","",index('order numbers'!e:e,a1))



Wayne26el wrote:

I have an excel worksheet which has a reference to another sheet (='Order
Numbers'!E448) I want to be able to replace the row number €œ448€� with number
that I would put in. I would leave the column designation as is. How can I
accomplish this?
Wayne

--

Dave Peterson