Hi,
I am trying to do a vlookup a value, but the table_array changes as more data added. How can the table_array updates automatically?
Here is my formula: VLOOKUP(N2514,'On Call Contracts'!$H$13673:$H$14935,1,FALSE). When I add more data to "On Call Contracts" sheet, the range changes. Is there a way to make the range dynamic that updates automatically instead of manually changing the range? The $H$13673:$H$14935 is a date range, like FY21 03. When I add more data, the range can change.
Thanks,
I am trying to do a vlookup a value, but the table_array changes as more data added. How can the table_array updates automatically?
Here is my formula: VLOOKUP(N2514,'On Call Contracts'!$H$13673:$H$14935,1,FALSE). When I add more data to "On Call Contracts" sheet, the range changes. Is there a way to make the range dynamic that updates automatically instead of manually changing the range? The $H$13673:$H$14935 is a date range, like FY21 03. When I add more data, the range can change.
Thanks,