matching formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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
 
Back
Top