Thread
:
How do I select a value from a table based on 2 conditional refs?
View Single Post
#
7
Posted to microsoft.public.excel.worksheet.functions
Puzzled Percy
Posts: n/a
How do I select a value from a table based on 2 conditional re
Thanks Bob,
Your formula works great too! This was more what I had in mind when I first
posted as I will be able to use text with it in a different scenario. You
are FANTASTIC :)
Regards,
Puzzled Percy
"Bob Phillips" wrote:
=INDEX(C1:C4,MATCH(1,(A1:A4=F1)*(B1:B4=G1),0))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Puzzled Percy" <Puzzled
wrote in message
...
I'm trying to select a value from a table based on 2 variable references.
If been looking at using a VLOOKUP function to do this but because there
are
2 dependant references I'm a little stuck. I thought that maybe a VLOOKUP
with a MATCH function incorporated might be an option as the entries in
each
column are not unique.
To give you an example of what I am trying to achieve I done the table
below.
Basically if F1=9 & G2=2 then select C1 (*)
A B C D F G
1 9 3 * % 9 2
2 9 2 % &
3 9 1 # *
4 7 3 * %
Thanks
Reply With Quote