Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Obtaining values for a cell in Excel from a separate Excel file
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying cell values to a external file in VBA | Excel Discussion (Misc queries) | |||
How do I convert an excel file into a comma separated values file | Excel Discussion (Misc queries) | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
How do I Auto-Filter with multiple values in a cell in Excel? | Excel Discussion (Misc queries) | |||
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) |