| 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) | |||
Threaded Mode
