Vlookup to insert dates

Tubbs49

New Member
Joined
Oct 2, 2014
Messages
6
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
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Steph77

Board Regular
Joined
Sep 18, 2014
Messages
119
In a spare column (say AZ):

=VLOOKUP(A1,AV:AW,2,0)

in another spare column

=IF(I1="",AZ1,I1)

Then copy-paste values back into column I
 

Watch MrExcel Video

Forum statistics

Threads
1,122,418
Messages
5,596,024
Members
414,037
Latest member
Roamingsmile

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top