a bit more explanation of what you are trying to do

--
Don Guillett
SalesAid Software

"aries0070" wrote
in message ...

I am trying get a data from the other sheet that matches the required
field. But it gives me FALSE result. Can you please help me on this.
Thanks in advance.

This is my example:
=IF(F7='Allowances Summary'!A6:A57,'Allowances Summary'!B6:B57)


--
aries0070
------------------------------------------------------------------------
aries0070's Profile:
http://www.excelforum.com/member.php...o&userid=25077
View this thread: http://www.excelforum.com/showthread...hreadid=385937