Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |