question using "INDEX" and "IF" functions

M

monkeytrader

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Adding sequence numbers to paragraphs 0
Transfer data between two tables 3
Dealing with the error: unable to filter on excel hc home school 0
Date diffrence in days, weeks and months. 1
Row reference for consecutive series calculation 0
Calculate days, months and weeks difrence 0
Range headings 0

Top