Ask Your Question
0

Get cell value by another's cell string [closed]

asked 2015-11-25 12:02:13 +0100

gregor23424 gravatar image

Hi,

is it possible to get a cell value by another's cell value/string? I need it to cross reference between different sheets.

For Example:

Cell: A1, Value = "20"

Cell: A2, Value = "A1"

Cell: A3, Value = function_get_value_by_cell_value(A2)

Desired output for Cell A3: "20"

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-13 16:02:33.903533

1 Answer

Sort by » oldest newest most voted
1

answered 2015-11-25 15:13:02 +0100

karolus gravatar image

Hallo

Use =INDIRECT(A2)

Karolus

edit flag offensive delete link more

Comments

thank you :-)

gregor23424 gravatar imagegregor23424 ( 2015-11-25 19:46:56 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2015-11-25 12:02:13 +0100

Seen: 1,158 times

Last updated: Nov 25 '15