I need to have a column of cells obtain its values from a separate Excel
file. Basically I need it to perform this:

If C2=851707-401 then G2=f2we0002

I have a file that has all this information stated, column A with the
primary, column B with the alternate.

The report that I need this operation to be performed in only comes with the
primary information. I then have to manually insert the alternate info for
each item. There are over 100 items and they repeat often.

Thanks for the help.