1

I have two sheets, one is a huge table of item ID's with a corresponding code column next to them. However over time this has not been properly filled in. I have assembled a complete list of item ID's and corresponding codes in another sheet.

I want Excel to fill in the blanks using the ID column as a key.

What's the easiest way to get Excel to look for the ID in the main sheet, and paste in the corresponding code from the other sheet?

pnuts
  • 58,317
  • 11
  • 87
  • 139
user3234810
  • 482
  • 2
  • 5
  • 18

1 Answers1

1

Rather than fill in just the blanks - and face the issue of how then to skip over cells already populated - use the same formula to fill in the blanks and to overwrite whatever happens to be present already.

pnuts
  • 58,317
  • 11
  • 87
  • 139