|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
If with AND - Is this correct?
It came back with #NA
"Max" wrote:
Believe this expression, array-entered with CTRL+SHIFT+ENTER (instead of just
pressing ENTER) will return what you're after:
=INDEX('Node 01'!H1:H1000,MATCH(1,('Node 01'!A1:A1000=A22)*('Node
01'!B1:B1000=B22),0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Greg" wrote:
What is wrong with this formula?
=IF(AND('Node 01'!A1:A1000=A22,'Node 01'!B1:B1000=B22),'Node 01'!H1:H1000,0)
Looking at "A" and "B" for a match and the anwser is "H" the same row as "A&B"
|