Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
question using "INDEX" and "IF" functions
i have 2 columns of data which correspond together. the cell in column "A"
and the cell in column "B" are pairs of data. i want to be able to lookup the two columns and print out the corresponding "match" into another cell. ex: A B C D 1 5 20 4 30 2 4 30 2 50 3 3 40 5 20 4 2 50 4 1 60 columns "A" and "B" are the data. columns "C" and "D" show what i want to make a function for. is it possible to write a function in column "D" to show that when column "C" has the number "4" in it, then it prints "30" in the cell from the data pulled from columns "A" and "B"? (in column "A", 1=60. 2=50. 3=40, etc) sorry for the vagueness. appreciate your help in advance! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
question using "INDEX" and "IF" functions
=VLOOKUP(C1,A1:B5,2,False)
-- __________________________________ HTH Bob "monkeytrader" wrote in message ... i have 2 columns of data which correspond together. the cell in column "A" and the cell in column "B" are pairs of data. i want to be able to lookup the two columns and print out the corresponding "match" into another cell. ex: A B C D 1 5 20 4 30 2 4 30 2 50 3 3 40 5 20 4 2 50 4 1 60 columns "A" and "B" are the data. columns "C" and "D" show what i want to make a function for. is it possible to write a function in column "D" to show that when column "C" has the number "4" in it, then it prints "30" in the cell from the data pulled from columns "A" and "B"? (in column "A", 1=60. 2=50. 3=40, etc) sorry for the vagueness. appreciate your help in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |