Hello,
I'm trying to find a way to have a cell follow data as a vlookup table shifts with additional data.
The sheet I have has a master list of quotation, where if they are active they populate onto a dashboard. Every time a new entry occurs, the vlookup shifts the data down the table.
There is a column next to the table that is not apart of the vlookup table, that has a drop down for status of the active quote. How do I get that cell to follow the data of the vlookup to shift down with changes? Is there a way to do this? Or best to just create this as a vlookup as well?
I'm trying to find a way to have a cell follow data as a vlookup table shifts with additional data.
The sheet I have has a master list of quotation, where if they are active they populate onto a dashboard. Every time a new entry occurs, the vlookup shifts the data down the table.
There is a column next to the table that is not apart of the vlookup table, that has a drop down for status of the active quote. How do I get that cell to follow the data of the vlookup to shift down with changes? Is there a way to do this? Or best to just create this as a vlookup as well?