Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell refrence based on specific criteria
I am trying to refrence a specific cell based on set criteria.
I have a cell with a current calcualtion. I am then wanting to find out what cell is associated with that number, for example I have ratios running along side a ratio count column (1, 2, 3, 4 and so on). In my new cell I'm trying to say if the count ='s the value in my current calculated cell, then this cells value is the ratio associated with that count column. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell refrence based on specific criteria
so, if your variable is in, say, cell C1 and your formula is in cell D1 with
your ratio column along column A and result column in B, you can put into D1: =vlookup(C1,A:B,2) This wil lreturn the nearest value from the column, so if C1 is 2.3, you'll get the value from your 2 column. If you don't want nearest match, only exact, then: =vlookup(C1,A:B,2,FALSE) HTH! "Jenn" wrote: I am trying to refrence a specific cell based on set criteria. I have a cell with a current calcualtion. I am then wanting to find out what cell is associated with that number, for example I have ratios running along side a ratio count column (1, 2, 3, 4 and so on). In my new cell I'm trying to say if the count ='s the value in my current calculated cell, then this cells value is the ratio associated with that count column. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell refrence based on specific criteria
In Cell C7 I have a calculation.
In Row E I have a range from 1 to 4034 (this may change depending on my data set ex. 1-50 or 1-60000) In Row F I have ratios that correlate with the range 1 to 4034. I would like to create a calcuation that will correlate cell c7(number may be 1 through 4034) to row f (my ratio), based on the numbers listed in row e (numbers 1 to 4034). "Sean Timmons" wrote: so, if your variable is in, say, cell C1 and your formula is in cell D1 with your ratio column along column A and result column in B, you can put into D1: =vlookup(C1,A:B,2) This wil lreturn the nearest value from the column, so if C1 is 2.3, you'll get the value from your 2 column. If you don't want nearest match, only exact, then: =vlookup(C1,A:B,2,FALSE) HTH! "Jenn" wrote: I am trying to refrence a specific cell based on set criteria. I have a cell with a current calcualtion. I am then wanting to find out what cell is associated with that number, for example I have ratios running along side a ratio count column (1, 2, 3, 4 and so on). In my new cell I'm trying to say if the count ='s the value in my current calculated cell, then this cells value is the ratio associated with that count column. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell refrence based on specific criteria
so, in cell D7, type =VLOOKUP(C7,E:F,2)
that ought to do it! "Jenn" wrote: In Cell C7 I have a calculation. In Row E I have a range from 1 to 4034 (this may change depending on my data set ex. 1-50 or 1-60000) In Row F I have ratios that correlate with the range 1 to 4034. I would like to create a calcuation that will correlate cell c7(number may be 1 through 4034) to row f (my ratio), based on the numbers listed in row e (numbers 1 to 4034). "Sean Timmons" wrote: so, if your variable is in, say, cell C1 and your formula is in cell D1 with your ratio column along column A and result column in B, you can put into D1: =vlookup(C1,A:B,2) This wil lreturn the nearest value from the column, so if C1 is 2.3, you'll get the value from your 2 column. If you don't want nearest match, only exact, then: =vlookup(C1,A:B,2,FALSE) HTH! "Jenn" wrote: I am trying to refrence a specific cell based on set criteria. I have a cell with a current calcualtion. I am then wanting to find out what cell is associated with that number, for example I have ratios running along side a ratio count column (1, 2, 3, 4 and so on). In my new cell I'm trying to say if the count ='s the value in my current calculated cell, then this cells value is the ratio associated with that count column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a cell refrence another cell based on conditions? | Excel Worksheet Functions | |||
Copy data to another wb based on specific criteria | Excel Discussion (Misc queries) | |||
Summing specific Columns based on Criteria | Excel Discussion (Misc queries) | |||
searching for specific criteria and then doing an action based on | Excel Discussion (Misc queries) | |||
I am trying to color fill a cell based on specific criteria | Excel Discussion (Misc queries) |