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. |
#2
|
|||
|
|||
Thông tin khá bổ Ã*ch, mong má»i ngÆ°á»i sẽ đóng góp nhiá»u hÆ¡n thông tin dạng nhÆ° thế nÃ*y để forum thêm phần Ä‘a dạng.
|
#3
|
|||
|
|||
|
#4
|
|||
|
|||
Quote:
|
#5
|
|||
|
|||
|
Reply |
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 |