Apr 30 2018 12:26 PM
I have a vlookup formula, it works great but when i expanded the table to add more entries, they don't appear in the look up tab.
=IFERROR(VLOOKUP(B41,Mat_tbl2,2,FALSE),"0")
I made sure that Mat_tble2 was expanded to add the new data and it's all inside Mat_tbl2, but when i go to select a new item, it's not there.
Apr 30 2018 01:39 PM
Can you please post an example file with non-sensitive data or provide pictures of your example lookup table along with the table with the formula? It's often easier to address the issue with a sample file or a more concrete example of the data representation.