Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
matching formula | Excel Worksheet Functions | |||
Help with matching formula | Excel Worksheet Functions | |||
matching formula | Excel Worksheet Functions | |||
Matching formula - i need help | Excel Discussion (Misc queries) | |||
Matching Formula | Excel Worksheet Functions |