Extracting a value from a table based on two arguments

DennisC

Beginner

Points

95

Posts

11
Oct 21st 2005
- #1
Please see attached spreadsheet for example. Thank you very much!
Files

Excel Question.xls 13.82 kB – 71 Downloads
Domenic

Super Moderator

Points

11,910

Posts

2,376
Oct 21st 2005
- #2
Re: Extracting a value from a table based on two arguments

Try...

=INDEX(E7:I11,MATCH(D3,D7:D11,0),MATCH(E3,E6:I6,0))

Hope this helps!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login

Share

This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.