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 ------------------------------------------------------------------------ tommyf's Profile: http://www.excelforum.com/member.php...o&userid=28511 View this thread: http://www.excelforum.com/showthread...hreadid=481017 |
best formula for finding a cell value?
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 |
best formula for finding a cell value?
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 |
best formula for finding a cell value?
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 |
best formula for finding a cell value?
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 |
All times are GMT +1. The time now is 10:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com