Using corresponding value of a Cell in a formula
 

How can I use a value of a cell in a formula?

For example:

A B C
test.com 2
test1.com 1
test3.com 3

in cell C1, if lookup the text result of a cell in Column A which correspnds
to value of Column B.
--
Fred K.

Using corresponding value of a Cell in a formula
 

Try this, with the value you're looking to reference entered in D1:

=Index(A1:A3,Match(D1,B1:B3,0))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"FredK" wrote in message
...
How can I use a value of a cell in a formula?

For example:

A B C
test.com 2
test1.com 1
test3.com 3

in cell C1, if lookup the text result of a cell in Column A which
correspnds
to value of Column B.
--
Fred K.

Using corresponding value of a Cell in a formula
 

Fred
I believe you need to look into the VLOOKUP formula.
But, you don't provide enough information for me to be completely sure
about that.
Ken

On Aug 6, 3:14*pm, FredK wrote:
How can I use a value of a cell in a formula?

For example:

A * * * * * * * * * * * B * * * * * * * * * * * * C
test.com * * * * * * 2
test1.com * * * * * 1
test3.com * * * * * 3

in cell C1, if lookup the text result of a cell in Column A which correspnds
to value of Column B.
--
Fred K.