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... |
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 |
All times are GMT +1. The time now is 02:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com