Complex Formula Help Required
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!!!! -- Laura -- Laura |
Complex Formula Help Required
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 "Laura Wild" wrote: 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!!!! -- Laura -- Laura |
All times are GMT +1. The time now is 10:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com