Thursday 15 March 2012

vlookup - Nested If statement Excel - checking if value exists -


I have a spreadsheet with multiple lines in the column, with different statistics such as:

 < Code> student book no book 1 book 2 book 3 book 4 book 5 x 12 y 13 12 23 23 32 What do I want to do to see if the book is present in any other table or whether or not the book exists If the icon is not in another spreadsheet to come back with  

I have the following code, although the book is not in the range, it returns back empty: '(There is no way to make it.

 < Code> = IF (ISNA (VLUKUP (Q3, 'Libby Books 21-06-13'! $ A: $ B, 2, FALSE), "VLOOKUP" (Q3, 'Libby Books 21-06-13'! $ A: $ B, 2, FALSE)   

Many thanks

< P> Change the "" of your formula to Value_if_true "NA" .
  = IF (VLUKUP (Q3, 'Libary Books 2 1-6-13 '! $ A: $ B, 2, with False), "NA", VLUKUP (Q3,' Libary Books 21-06-13 '! $ A: $ B, 2, False) Edit based on the comment:  The best way to understand these types of nested formulas is to make them as simple as possible so that you can make sure that what happens.  

I set up two columns, book column A and nested if name on a sheet in column B IF (ISNA (A2) , IF (A2 = "", "does not exist", A2))

I have copied and pasted that thread in all the rows. Result:

  Book name nested if the sun rises then the sun rises # n / a   

You use the formula above as your template can do.

No comments:

Post a Comment