Hello,

I have created a matrix which has three columns: "north", "south" and
"west". The rows below the columns are sequenced by their respective
row number and below each column has different values.

My questions is: If I create three cells- "Direction","Row" and
"Value", how can I populate the intersecting value in "Value" by when I
input in "Direction" and "Row"??

Example: Direction = north; Row = 2; Value = [would this be a DGET or
IF function?]

Thanks in advance for your responses!!


--
tommyf
------------------------------------------------------------------------
tommyf's Profile: http://www.excelforum.com/member.php...o&userid=28511
View this thread: http://www.excelforum.com/showthread...hreadid=481017

Hi,
Try something like this:
A1 = direction
B1 = Row
C1 = HLOOKUP(A1,your_range,B1,0)

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=481017

How about an HLOOKUP formula?:
where A1:C1 contain "north, south, west", D1=direction and E1=row
number; place in F1:

=HLOOKUP(D1,A1:C50,E1+1,0)

(note the formula adds 1 to row value E1, as HLOOKUP counts the Header
as row 1, so if you want the first value in the table, enter 1, the
formula adds 1 to give you the 2nd row in the table)

of course, adjust ranges to meet your needs.

Good luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=481017

Pinmaster- Your formula worked!! Thanks!!!



best formula for finding a cell value?

--------------------------------------------------------------------------------

Hello,

I have created a matrix which has three columns: "north", "south" and
"west". The rows below the columns are sequenced by their respective
row number and below each column has different values.

My questions is: If I create three cells- "Direction","Row" and
"Value", how can I populate the intersecting value in "Value" by when I
input in "Direction" and "Row"??

Example: Direction = north; Row = 2; Value = [would this be a DGET or
IF function?]

Thanks in advance for your responses!!

tommyf
View Public Profile
Send a private message to tommyf
Find all posts by tommyf
Add tommyf to Your Buddy List

#2 Today, 12:20 PM
pinmaster is Offline:
Registered User Join Date: Feb 2004
Location: Canada
Posts: 271

Hi,
Try something like this:
A1 = direction
B1 = Row
C1 = HLOOKUP(A1,your_range,B1,0)

HTH
JG


--
tommyf
------------------------------------------------------------------------
tommyf's Profile: http://www.excelforum.com/member.php...o&userid=28511
View this thread: http://www.excelforum.com/showthread...hreadid=481017

Hi Tommy

Your welcome! And thanks for the feedback!

Regards

JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=481017