| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to Run a Formula on the Combinations of Info from Different Books
Trying to make a quick solution to a problem I have come across. If a combo of cells in Row 1 (R1) workbook 1 (WB1) matches the same combination in any row of workbook two (WB2), then return value of cell A1 from WB2 in cell 10 of the row of WB1. Anyone know a formula for this?
IF AMO cell C2 is US and F2 is 01CV for J2, and the same for Array AMO Data Pull where B2 is 01CV and A2 is PSG-US for D2, the value is AMO Data Pull M2. Or IF AMO cell C2 is US and F2 is IDS for J2, and the same for Array AMO Data Pull where B2 is IDS and A2 is PSG-US for D2, the value is AMO Data Pull M2. Or IF AMO cell C2 is US and F2 is 0753 for J2, and the same for Array AMO Data Pull where B2 is 0753 and A2 is PSG-US for D2, the value is AMO Data Pull M2. Or IF AMO cell C2 is CA and F2 is IDS for J2, and the same for Array AMO Data Pull where B2 is IDS and A2 is PSG-CANADA for D2, the value is AMO Data Pull M2. Or IF AMO cell C2 is CA and F2 is 0753 for J2, and the same for Array AMO Data Pull where B2 is 0753 and A2 is PSG-CANADA for D2, the value is AMO Data Pull M2. Or IF AMO cell C2 is CA and F2 is 01CV for J2, and the same for Array AMO Data Pull where B2 is 01CV and A2 is PSG-CANADA for D2, the value is AMO Data Pull M2. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for number combinations. | Excel Worksheet Functions | |||
| Formula for number combinations. | Excel Worksheet Functions | |||
| Help with a formula: Data Combinations | Excel Discussion (Misc queries) | |||
| How do I match 2 cols on two books and get price info for all matc | Excel Worksheet Functions | |||
| Help adding info from Multiple Books to 1 sheet. | Excel Programming | |||
Threaded Mode
