Can Vlookup be used to display a value from another sheet then also update source when you input into that vlookup cell/?
I have a simple dummy file that spells everything out.
The drop down pulls in the operator name,then the vlookups in the small tables display the data from the main sheet. (I know I could probably could use a Pivot Table, but I am better with simple VLookup than Pivots)
Inside each table I would love to be able to input data and it would update the main data sheet with a push of the "update button".
A confirmation "Yes/No" prompt should be used if possible.
Thanks so much.