ExcelBanter - Trying to Run a Formula on the Combinations of Info from Different Books

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Trying to Run a Formula on the Combinations of Info from Different Books (https://www.excelbanter.com/excel-discussion-misc-queries/452919-trying-run-formula-combinations-info-different-books.html)

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.

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.

Cáº£m Æ¡n báº¡n nhiá»u
_________________
mÃ¡y cáº¯t laser

https://t.co/2gSucCgcoT

Quote:

Originally Posted by (Post 1627552)

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.

link vwin Ä‘ang nháº*p nhanh, cáº*p nháº*t link vÃ*o happy8 má»›i nháº¥t trong nÄƒm, [url=https://goo.gl/9blTRi]Ty Le Bong Da cáº*p nháº*t kÃ¨o chÃ*nh xÃ¡c nháº¥t

Vote cho báº¡n
_________________
khac laser

https://t.co/9U1K8VU4OQ