Posted to microsoft.public.excel.misc

pol

external usenet poster

Posts: 129

countif and Vlookup

I given the following formula

IF(COUNTIF([item.xls]sheet1!A:C,G7),TRUE,FALSE) , the result is showing as
true if the record exist in item.xls . At the same time I wrote another
VLOOKUP(G7,[item.xls]sheet1!A:C,3,0) the result is showing as '#NA' for the
same record which already showed as true in Countif .

Please anybody can help me to get the reason for the diffrent result in
both function;.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF and VLOOKUP	mpenkala	Excel Worksheet Functions	3	April 10th 08 10:20 PM
countif w/vlookup	sjl	Excel Discussion (Misc queries)	2	February 16th 07 03:05 PM
vlookup and countif???	Joe	Excel Worksheet Functions	5	March 13th 06 10:33 AM
Countif or Vlookup	praveen_khm	Excel Worksheet Functions	1	February 3rd 06 08:17 PM
Countif? or Vlookup? Lost??	leo	Excel Worksheet Functions	3	November 30th 05 02:17 PM

All times are GMT +1. The time now is 07:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us