Is it possible to make a formula that steps through the sheets in it or another
file without knowing each sheets name?
I know scripting can do it, but I was wondering if there was a way to define
sheets by an number or something... So if I wanted to do a vlookup on say sheet
number 3 and have t
I have an array formula that is returning an error of #VALUE when it
shouldn't.The formula is below.
{=ISERROR(INDEX($'Sales
4-10-2017'.$A$1:$A$1000;SMALL(IF(ISERROR(FIND("Discount";$'Sales
4-10-2017'.$A$1:$A$1000))=0;ROW($'Sales
4-10-2017'.$A$1:$A$1000);"");ROW(A200}
Digging into it, it s
lt {} _filtered #yiv3704922496 {margin:1.0in 1.0in
1.0in 1.0in;}#yiv3704922496 div.yiv3704922496WordSection1 {}#yiv3704922496 I am
not sure, but if you expect Find to return a number, try N(FIND(…)) instead –
it converts value into a number. Howard From: ouch
Sent: Tuesday, April 11, 2017
