Home |
Search |
Today's Posts |
#1
|
|||
|
|||
precedent
I want to use a precedent in a formula with an easy command.
As an example: I have =MATCH(B6,$C:$C,0) in cell #X. [MATCH(lookup_value,lookup_array,match_type)] I want to create a formula in a blank cell like this: If lookup_value in cell #X (which is B6) is bla bla do bla bla.... I cannot find a way to trace the precedent (B6). I do not know how to use SQL or anything likewise (except standard Excel formulations and basic JAVA) I'd appreciate any help... |
#2
|
|||
|
|||
Maybe something like this in say, D6:
=IF(B6="","",MATCH(B6,$C:$C,0)) which will keep D6 blank until there's a value in B6 for the evaluation of the MATCH -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "IcyMan" wrote in message ... I want to use a precedent in a formula with an easy command. As an example: I have =MATCH(B6,$C:$C,0) in cell #X. [MATCH(lookup_value,lookup_array,match_type)] I want to create a formula in a blank cell like this: If lookup_value in cell #X (which is B6) is bla bla do bla bla.... I cannot find a way to trace the precedent (B6). I do not know how to use SQL or anything likewise (except standard Excel formulations and basic JAVA) I'd appreciate any help... |
#3
|
|||
|
|||
But you wrote B6 in your formula. If you are tracing the precedent which is
B6 in this example, you shouldn't use it in your formula. That has to be your result. Like using lookup_value in formula and getting B6 in the result.. "Max" wrote: Maybe something like this in say, D6: =IF(B6="","",MATCH(B6,$C:$C,0)) which will keep D6 blank until there's a value in B6 for the evaluation of the MATCH -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "IcyMan" wrote in message ... I want to use a precedent in a formula with an easy command. As an example: I have =MATCH(B6,$C:$C,0) in cell #X. [MATCH(lookup_value,lookup_array,match_type)] I want to create a formula in a blank cell like this: If lookup_value in cell #X (which is B6) is bla bla do bla bla.... I cannot find a way to trace the precedent (B6). I do not know how to use SQL or anything likewise (except standard Excel formulations and basic JAVA) I'd appreciate any help... |
#4
|
|||
|
|||
Then my guess was out as to what you meant by:
" .. tracing the precedent .. " Maybe hang around awhile for better views from others .. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "IcyMan" wrote in message ... But you wrote B6 in your formula. If you are tracing the precedent which is B6 in this example, you shouldn't use it in your formula. That has to be your result. Like using lookup_value in formula and getting B6 in the result.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I "CTRL [" (jump to a precedent cell) from a European keybo | Excel Discussion (Misc queries) |