Using corresponding value of a Cell in a formula

F

FredK

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.
 
R

RagDyer

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

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

Ken

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Cumulative formula for word table 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Drop down list control value in vba 2
Excel does not accept text format! 0
Extracting a cell value 2
Copy corresponding cell in Column B if cell in A contains certain text? 1

Top