Re: Huge "IF" formula help.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi!

Try this:

=INDEX(G1:O1,MATCH(9.99999999999999E+307,G2:O2))

Biff

"sungen99" <sungen99.2001an_1134511801.5199@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:sungen99.2001an_1134511801.5199@xxxxxxxxxxxxxxxxxxxxxxxx
>
> Ok does this help?
>
>
> G1 is 3P100 H1 is 3P200 I1 is 3P250 J1 is 3P322 K1 is 3P532 L1 is
> 3P555 M1 is 3P560 N1 is 3P667 O1 is 3P800
>
> As I said the trades run for A1 to A100 or whatever.
>
> So A1 has Sold 100 in it. and because it was done for the 3P532
> account the number of contracts sold (lets say 10) is found in K1
>
> What I want to do is have P1 show the NAME of the account that did the
> trade. In this case P1 would show "3P532"
>
> There will never be a case where there are more than one trade per
> line.
>
> Thanks again for the help,
>
> Ken
>
>
> --
> sungen99
> ------------------------------------------------------------------------
> sungen99's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=9144
> View this thread: http://www.excelforum.com/showthread.php?threadid=493117
>


.

Quantcast