Quote:
Originally Posted by Max
Something like this in say D1, array-entered*:
=INDEX(C2:C10,MATCH(1,(A2:A10="Name1")*(B2:B10=3), 0))
Press CTRL+SHIFT+ENTER to confirm the formula
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"slezgus" wrote:
I have two tables of pretty much the same format. Column A shows a name that
may or may not be repeated a few times, while column B shows one of four
values (say, 1, 2, 3, 4). I need a formula that will return the result of
the third column, if it matches Column A and Column B. |
Hi the
Thank you.. this formula works great!
I was wondering how, if at all, I can use the IFNA with the Index+Match formula above.
I tried using it this way but I ended up with a #NA
Quote:
|
=IFNA(INDEX(ActualHours!C$1:C$200,MATCH(1,($A3=Act ualHours!$A$1:$A$200)*($B3=ActualHours!$B$1:$B$200 ),0)),"")
|
(ended it with a ctrl +shift + enter)
Thanks for your help...
Similar Threads
Threaded Mode
