Look up

F

Frank Kabel

Hi
try the following array formula (entered with
CTRL+SHIFT+ENTER):
=INDEX(C1:C100,MATCH(1,(A1:A100="value1")*
(B1:B100="value2"),0))
-----Original Message-----
Im trying to right a look up which does the following

Looks in an array which consists of 3 columns.
If it finds two specifed values in the 1st two columns,
Click to expand...
it returns the value in the 3rd column
 

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

Looping through permutations 7
Using SUMIF with AND 2
named arrays in other workbooks 0
Tracking using =sumproduct 3
need help in fine-tuning a formula that removes blank cells in a column range 3
Checking Column Status on closing excel - Macro Needed 2
index question 4
Multi-demensional frequency distribution 4

Top