Hello, Actually I have to update a master google excel sheet daily with numeric values. There are thousands of names across which value to be updated daily by datewise (new date in new column).
Daily I get names with num values which eventually to be entered in their respective cell of a new date. By vlookup I get the info of cells that are empty & need to update. Till now I am using search and find option to go to the required cell (of required date) & update the value by fixing the column of names in google sheet. Is there any way by which I can change the respective values without opt for search & find because there are many names in table.
is there any way by which I can directly update those values if I have the values to be updated in one column & just replace them by using formula. Just as vlookup only does help in finding the value whether its filled or not, but I want to update that value without doing ctrl+f for each name. Thank you.
Daily I get names with num values which eventually to be entered in their respective cell of a new date. By vlookup I get the info of cells that are empty & need to update. Till now I am using search and find option to go to the required cell (of required date) & update the value by fixing the column of names in google sheet. Is there any way by which I can change the respective values without opt for search & find because there are many names in table.
is there any way by which I can directly update those values if I have the values to be updated in one column & just replace them by using formula. Just as vlookup only does help in finding the value whether its filled or not, but I want to update that value without doing ctrl+f for each name. Thank you.