Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 7th, 2012  |  syntax: None  |  size: 0.45 KB  |  hits: 15  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Excel formula using 2 sheets
  2. Sheet1                  Sheet2              
  3.  
  4.         *???            |              modelA   modelB  modelC
  5. typeA   100   modelA    |       typeA   100     1        1
  6. typeB   50    modelB    |       typeB   1       50       1  
  7. ...                     |       ...        
  8. typeY   20    modelA    |       typeY   20      1        1
  9.        
  10. =INDIRECT("sheet2!"&ADDRESS(MATCH(A1, Sheet2!$A$1:$A$5), MATCH(C1, Sheet2!$A$1:$D$1)))
create a new version of this paste RAW Paste Data