Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is this possible ?
I would like to create a cell address ie. ( B3 ) from the results of two if
statements. One if statement provides me the Column ( B ) the other provides the row ( 3 ) I need to know if I can take the results of the IF statements the B and the 3 and create a cell address B3 so I can point to the value in that cell. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is this possible ?
You can use the Indirect function, as in:
=indirect("B3") or, =indirect(if(a1=a2,"B3","C3")) or, =indirect(if(a1=a2,"B","C")&if(a3=a4,"3","4")) etc. Regards, Fred "W.R" wrote in message ... I would like to create a cell address ie. ( B3 ) from the results of two if statements. One if statement provides me the Column ( B ) the other provides the row ( 3 ) I need to know if I can take the results of the IF statements the B and the 3 and create a cell address B3 so I can point to the value in that cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|