Hi guys
Im stuck with something that i don't know if its even possible. First of all this is for excel 2000.
I already have a way do get a record from A3:G41 with two conditions (formula on cell P4). What i need is a way to populate others cells (or another table) if the values in L4 and M4 match with the ones in column C and D. For example i have 300 in L4 and 16 in M4, what i need is a way to show me the values from C4 to H4, C29 to H29 and C30 to H30, the ones that match. I need this because using the conditions in L4 and M4 to get the values that match in the other table those values will be use for the graph, but i think this will maybe be a little tricky..
Sorry if my explanation is weak :-p
Is this possible?
Thanks in advance ;-)
Bookmarks