Hello, I have a problem to solve as follows:
Column A has ID numbers 1 to 90,000
Column AV has the same ID numbers but in a different order.
Column AW has dates corresponding to the ID's in Column AV
Column I is the date column already with some dates that must remain
How can I use VLOOKUP or another function to search ID's from Col AV with Col A and trnsfer the corresponding date from AW into any blank cells in Col I
Column A has ID numbers 1 to 90,000
Column AV has the same ID numbers but in a different order.
Column AW has dates corresponding to the ID's in Column AV
Column I is the date column already with some dates that must remain
How can I use VLOOKUP or another function to search ID's from Col AV with Col A and trnsfer the corresponding date from AW into any blank cells in Col I