Thread: List Query
View Single Post
  #2   Report Post  
Max
 
Posts: n/a
Default

Try instead in say, G7:
=INDEX('Allowances Summary'!$B$6:$B$57,MATCH(F7,'Allowances
Summary'!$A$6:$A$57,0))
Copy G7 down to retrieve data for the other values in F8, F9, etc

Alternatively, with an error trap to return blanks:"" for unmatched values
instead of ugly #N/As, you could put in G7, and copy down:
=IF(ISNA(MATCH(F7,'Allowances Summary'!$A$6:$A$57,0)),"",INDEX('Allowances
Summary'!$B$6:$B$57,MATCH(F7,'Allowances Summary'!$A$6:$A$57,0)))
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"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