#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default matching formula

I need a formula that will link 2 worksheets matching 2 variables from the
secondary and primary and having the answer appear from a specified cell
(column) in the secondary appear on the primary. Major project for work and
need help...
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default matching formula

you can use INDEX and MATCH functions. =INDEX(A1:A10,MATCH(B12&B13,B1:
B10&C1:C10,0))
A1:A10 is where the anser will come from based and B12 in range B1:B10 and
B13 will be looked up in C1:C10. Hope that makes sense, someone else might
be able to better explain it. Index is also an array function so you have to
hit CTRL+SHIFT+ENTER after writting the formula



MsCarter wrote:
I need a formula that will link 2 worksheets matching 2 variables from the
secondary and primary and having the answer appear from a specified cell
(column) in the secondary appear on the primary. Major project for work and
need help...


--
Message posted via http://www.officekb.com

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
matching formula Todd Excel Worksheet Functions 2 June 1st 06 06:06 PM
Help with matching formula Soth Excel Worksheet Functions 2 May 1st 06 05:08 PM
matching formula Todd Excel Worksheet Functions 7 February 11th 05 10:56 PM
Matching formula - i need help bentleybr Excel Discussion (Misc queries) 1 December 7th 04 01:48 PM
Matching Formula Steve H. Excel Worksheet Functions 6 November 30th 04 09:00 PM


All times are GMT +1. The time now is 07:00 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"