Help me for exact formula

  • Thread starter Thread starter vlook fomula
  • Start date Start date
V

vlook fomula

Thanks Roger Govier the problem has been solved but let me know i had try
your given formula also as follow
=IF(COUNTIF(Sheet1!A:A,Sheet3!A2),VLOOKUP(Sheet3!A2,Sheet1!$A$2:$C$4,3,0),VLOOKUP(Sheet3!A2,Sheet2!$A$2:$C$4,3,0))
and got good result, is this application correct because it is easy and will
not creat problem in future.

thanks in advance
Zafar
 
You have the same argument defined for both the value_if_true and the
value_if_false. You probably want this:

=IF(COUNTIF(Sheet1!A:A,Sheet3!A2),VLOOKUP(Sheet3!A2,Sheet1!$A$2:$C$4,3,0),"")

If the lookup value is not found then the formula will return a blank.
 
You have the same argument defined for both the value_if_true and the
value_if_false. You probably want this:

=IF(COUNTIF(Sheet1!A:A,Sheet3!A2),VLOOKUP(Sheet3!A2,Sheet1!$A$2:$C$4,3,0),"")

If the lookup value is not found then the formula will return a blank.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help me for exact Formula 6
Problem with formulas 4
IF Statement Problem 4
formula referring to a worksheet 3
Duplicating cells with formula's 3
Multiple columns using Vlookup 3
VLOOKUP - returning the searched for value if it does not exist 7
SUMIF function and cell /sheet reference 3

Back
Top