Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula required | Excel Discussion (Misc queries) | |||
Help with a formula required please | Excel Discussion (Misc queries) | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula Help Required | Excel Discussion (Misc queries) | |||
Help required for formula | Excel Discussion (Misc queries) |