Here is what I am trying to do:
I have different names in a cell. If the name matches another cell on the same worksheet, the data I enter to the right in the next two cells transfers that data to the right two cells of the matched name. Currently I am entering it twice because the names are in different rows and columns but if a name matches, I would like to only enter the data once in the next to cells to the right and have it transfer the exact data.
Thanks in advance!
I have different names in a cell. If the name matches another cell on the same worksheet, the data I enter to the right in the next two cells transfers that data to the right two cells of the matched name. Currently I am entering it twice because the names are in different rows and columns but if a name matches, I would like to only enter the data once in the next to cells to the right and have it transfer the exact data.
Thanks in advance!