Help me for exact formula

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
 
T

T. Valko

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

Formula fill series? 1
Help me for exact Formula 3
macro for calculate and compare 0
Problem with formulas 4
IF Statement Problem 4
Help with setting up a formula 2
SUMIF function and cell /sheet reference 3
Multiple columns using Vlookup 3

Top