=INDEX('sheet2'!$A$2:$H$189,MATCH(B15,'sheet2'!$A$2:$A$189,FALSE),1)
I know the value of sheet 1 b15 is in sheet 2 column A. It keeps giving me an NA# answer. I am obviously missing something small.
Thanks!
This message was edited by EdE on 2002-04-25 10:12
I know the value of sheet 1 b15 is in sheet 2 column A. It keeps giving me an NA# answer. I am obviously missing something small.
Thanks!
This message was edited by EdE on 2002-04-25 10:12