how do I return value of a referenced cell?

**dreamwalker** · 03-13-2011, 06:44 AM

Hi,

I used the match() and address() functions and was able to get a reference address in the form of: $H$820

How can I now make a specific cell display the contents of the referenced cell?

thx!
dw

**canapone** · 03-13-2011, 07:03 AM

Hi, maybe you need

=INDIRECT("$H$820")

Regards

**martindwilson** · 03-13-2011, 07:03 AM

look at index/match
http://www.contextures.com/xlfunctions03.html

**dreamwalker** · 03-13-2011, 07:26 AM

thank you very much!!!

indirect() doesn't seem to work

index() did the trick though, many thanks

how do I return value of a referenced cell?

LinkBack

Thread Tools

Rate This Thread

Display

how do I return value of a referenced cell?

Re: how do I return value of a referenced cell?

Re: how do I return value of a referenced cell?

Re: how do I return value of a referenced cell?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions