looking up value in chart
I am creating a worksheet and I need help with a formula. I have a chart 5
rows by 6 colums on page 1. On page 2, I have two colums that I will fill in with which row and colum to use. How do I execute which row/collum to look in? example: a2 states the colum and a3 states which row. a4 would give the reference value of both a2+a3. Thanks |
Assuming that when you say it is referring to the column you mean a value of "A"... =INDIRECT(A2 & A3) -- kraljb ------------------------------------------------------------------------ kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955 View this thread: http://www.excelforum.com/showthread...hreadid=390716 |
enter in A4
=VLOOKUP(A2,Sheet1!$A$3:$F$7,A3,FALSE) you can extend the formula to the right. A2 is a number in the first column of your table the first column needs to be sorted (ascending values) you may want to add a help column as the first i.e. 1,2,3,4,5,6. the value in A3 is the column number from the left including the first. -- Greetings from New Zealand Bill K "Re2112" wrote in message ... I am creating a worksheet and I need help with a formula. I have a chart 5 rows by 6 colums on page 1. On page 2, I have two colums that I will fill in with which row and colum to use. How do I execute which row/collum to look in? example: a2 states the colum and a3 states which row. a4 would give the reference value of both a2+a3. Thanks |
Thank ya'll for the help. I made it work with =Index. I will try the Vlookup
on another part of my workbook. Thanks again "Bill Kuunders" wrote: enter in A4 =VLOOKUP(A2,Sheet1!$A$3:$F$7,A3,FALSE) you can extend the formula to the right. A2 is a number in the first column of your table the first column needs to be sorted (ascending values) you may want to add a help column as the first i.e. 1,2,3,4,5,6. the value in A3 is the column number from the left including the first. -- Greetings from New Zealand Bill K "Re2112" wrote in message ... I am creating a worksheet and I need help with a formula. I have a chart 5 rows by 6 colums on page 1. On page 2, I have two colums that I will fill in with which row and colum to use. How do I execute which row/collum to look in? example: a2 states the colum and a3 states which row. a4 would give the reference value of both a2+a3. Thanks |
All times are GMT +1. The time now is 01:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com