Complex Formula Help Required

[Laura Wild]

I have a workbook containing 28 worksheets - these sheets are all linked in
some manner. I need to be able to take from "Worksheet A" - 2 different
criteria from 2 different columns in that Worksheet and then reference
another linked wooksheet "Worksheet B". I need to take the criteria from
"WSA" have it look at "WSB" in two different columns on that worksheet and
see that those criteria match. Then pull info from column 3 o WSB if column
1 & 2 match on both WSA & WSB and place that info from column 3 back onto WSA
in a specific column. HELP!!!!

 

[Mike H]

Hi,

How about this. It takes the values in g1 & h1 on the active sheet and
looks for those values in columns A & B of WSB (another sheet) and if it
finds them returns column C. Did I understand correctly?

=INDEX(WSB!C1:C20,MATCH(1,(WSB!A1:A20=G1)*(WSB!B1:B20=H1),0))

This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array


Mike