Hi everyone,
Reference to the attached workbook, I have a formula in range G3:G58 that uses the VLOOKUP function to extract and return the data from the Data sheet, by matching the number in range C3:C58 with the number in A column of the Data sheet.
My project sometimes requires that I overwrites one of the cell names in range E3:E58 with the same name as in range D3:D58 cells.
I need please to edit the formula in range G3:G58 to return an equal time value in the respective row of range M3:M58 cells in the case that the name in range E3:E58 cell is the same as in the row of range D3:D58 cells.
Example; reference to the attached workbook, E5 name was manually overwritten with the same name as in D5, therefore the expected new formula in G5 should return an equal time value as in M5 which happen to be in this case 1:21 instead of (1:25).
Any help is highly appreciated.
Bookmarks