this breaks from one line in the table and the next.
on line 33 of the table it returns the proper answer one line 34 it goes to #value !
now the table it is looking up ends on line 33 but that shouldn't matter as far as I can tell!
As your table ends at line 33 your formula will not understand the tablecommands, like [@CR], used in your formula.
Make sure your table consist the correct number of lines before creating formula's with dynamic table commands within.
Ok so extending the array that was the target of the vlookup fixed the issue, but I don't understand why I should have to do that. The @cr is part of the table I'm working on and it exist. Its the array that is the target.
So the table has like 50 enteries, one of those entries on each record is a number between 1-25. Then it looks up info on another table that goes 1-25. I basically had to add a bunch of blank lines to the 1-25 table and that makes no sense to me.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
