vlookup

[Tyler Baldwin]

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.

[#2]

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.