Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Function
I believe I need to use VLOOKUP...but I am not sure, and I have no clue how
that function works. In one column I have years 2008 - 2060. In the next column I have %. I want Excel to return the year where either 75 % or 90 % is identified. How does VLOOKUP work for this problem? or is there a different way OTHER THAN looking at my data and seeing which year is related to the 75/90 %. I am creating tables in two differnet spreadsheets and I want the cells linked. I believe it will be easier to use a function rather than looking up the data myself, should information change in the future, causing different years to become associated with either 75/90 % Thanks for the help in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Function
On Oct 21, 3:49*pm, scott wrote:
I believe I need to use VLOOKUP...but I am not sure, and I have no clue how that function works. In one column I have years 2008 - 2060. In the next column I have %. I want Excel to return the year where either 75 % or 90 % is identified. How does VLOOKUP work for this problem? or is there a different way OTHER THAN looking at my data and seeing which year is related to the 75/90 %. I am creating tables in two differnet spreadsheets and I want the cells linked. I believe it will be easier to use a function rather than looking up the data myself, should information change in the future, causing different years to become associated with either 75/90 % Thanks for the help in advance. Vlookup can only search on the leftmost column of an area, so it won't work for you. What happens if both percents exist? I'd probably use 2 cells just in case. Like so: =INDEX(A1:B100,MATCH(.75,B1:B100,0),1) =INDEX(A1:B100,MATCH(.9,B1:B100,0),1) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Function
VLOOKUP is used to find value in one column and return a value from a column
to the right - you want a column to the left If there is a value of 75% in B1:B15, then this formula =INDEX(A1:A15,MATCH(75%,B1:B15,FALSE)) will return the year from the cell in column A, if there is no 75% you get an error result of #N/A Come back with more details if you wish best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "scott" wrote in message ... I believe I need to use VLOOKUP...but I am not sure, and I have no clue how that function works. In one column I have years 2008 - 2060. In the next column I have %. I want Excel to return the year where either 75 % or 90 % is identified. How does VLOOKUP work for this problem? or is there a different way OTHER THAN looking at my data and seeing which year is related to the 75/90 %. I am creating tables in two differnet spreadsheets and I want the cells linked. I believe it will be easier to use a function rather than looking up the data myself, should information change in the future, causing different years to become associated with either 75/90 % Thanks for the help in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function that can return the row number | Excel Worksheet Functions | |||
Return value for a function. | Excel Discussion (Misc queries) | |||
Why does this function NOT return a value? | Excel Discussion (Misc queries) | |||
Only do Sum function if not "0", IF"0" then return "0" | Excel Worksheet Functions | |||
Function to return value from each tab | Excel Worksheet Functions |