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

Scrabble Value calculation for Welsh words 0
Sum per row and Average per column from a second sheet. 6
How to concatenate cells that meets a specific criteria in threecolumns 6
Concatenate with differents conditions 3
Excel Help with dates 2
How to use autofilter in excel with formula reference changing 1
Column header for Max value? Index/array function? 5
Using drop-down lists 4

Top