Forum Discussion
Formula not working - is it because we are using an older Excel version?
SergeiBaklan JanePG Sergei, it would appear your formula also doesn't work for pre-DA and that is your answer Jane that it appears you have dynamic arrays and your husband does not. I suspect if you type =FILTER you will see information about it while your husband's version would only show FILTERXML as a valid function.
They are still rolling DA out so it is still possible your husband may get it soon.
As for your formulas please note the your "LEFT(... , 1)" is purely summing the first character and if those values exceed 1 digit OR if the corresponding values in the table change (e.g. 2today has "5" in col B) that formula will not work.
Hello JanePG,
Without seeing the data that you are working with, it would be difficult to fully diagnose your problem. As a note, the VLOOKUP() function has the arguments:
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
- Your function takes E5:E8 as the lookup_value. Did you intend for this to be the table_array?
- The table_array value is jpg. Is this meant to be the lookup_value? As a note, if the lookup_value is a text value then it should be surrounded by quotes (""). For example, "jpg".
- The col_index_num is 2 but there are not 2 columns in the referenced table_array.
Please review these notes and provide a little more additional information regarding the results you intend to receive and I would be more than happy to help solve your problem!
