The vba code below changes the value in a cell based on a vlookup. What I am not able to do is instead of having to change the value in 4 cells, change it so that only one cell (1) is changed to 1,2,3 then the cells in D1 D2 D3 D4 E1 E2 E3 E4 are updated using the values from ID that matches the digit in column 1. Thank you .


Named Range: ID

Please Login or Register  to view this content.
vba to change value in column 4 using 2 named range

Please Login or Register  to view this content.
vba to change value in column 5 using 3 in the named range 
Please Login or Register  to view this content.
desired

Please Login or Register  to view this content.