Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Junior Member
 
Posts: 5
Default

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   Report Post  
Banned
 
Posts: 1
Default

Cảm Æ¡n bạn nhiá»u
_________________
máy cắt laser

https://t.co/2gSucCgcoT
  #4   Report Post  
Banned
 
Posts: 11
Default

Quote:
Originally Posted by View Post
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
  #5   Report Post  
Banned
 
Posts: 2
Default

Vote cho bạn
_________________
khac laser

https://t.co/9U1K8VU4OQ
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for number combinations. The Deacon[_2_] Excel Worksheet Functions 3 September 29th 09 12:29 PM
Formula for number combinations. The Deacon[_2_] Excel Worksheet Functions 1 March 25th 09 05:49 AM
Help with a formula: Data Combinations Maureno Excel Discussion (Misc queries) 3 October 22nd 08 02:45 PM
How do I match 2 cols on two books and get price info for all matc Sonny Excel Worksheet Functions 1 August 26th 06 02:45 PM
Help adding info from Multiple Books to 1 sheet. RandyR Excel Programming 0 September 19th 05 07:54 PM


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"