Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pie chart on a pie chart (exploded)? | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel |