A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

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



 
 
Thread Tools Display Modes
  #1  
Old December 5th 16, 09:45 PM 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.
Ads
  #2  
Old December 6th 16, 03:42 AM
Luannguyen992 Luannguyen992 is offline
Junior Member
 
First recorded activity by ExcelBanter: Nov 2016
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  
Old December 6th 16, 09:24 AM
DungSport DungSport is offline
Banned
 
First recorded activity by ExcelBanter: Dec 2016
Posts: 1
Default

Cảm ơn bạn nhiều
_________________
máy cắt laser

https://t.co/2gSucCgcoT
  #4  
Old December 7th 16, 12:37 AM
Hslebbng030 Hslebbng030 is offline
Banned
 
First recorded activity by ExcelBanter: Dec 2016
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  
Old December 7th 16, 01:26 PM
seoclerks.com seoclerks.com is offline
Banned
 
First recorded activity by ExcelBanter: Nov 2016
Posts: 2
Default

Vote cho bạn
_________________
khac laser

https://t.co/9U1K8VU4OQ
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 04: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 03:30 AM.


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