if-then-else in VLOOKUP function

[Himansu]

Hello everyone,

Does anyone how to add an "if-then-else" in a vlookup? Here's an example:

=VLOOKUP(E348,Sheet1!A:B,2,FALSE)

---

* Basically I want the formula above to return the value in E348 if the
result is #N/A in the vlookup function above.

Any help with this query will be greatly appreciated.

 

[Dave Peterson]

=if(isna(VLOOKUP(E348,Sheet1!A:B,2,FALSE)),e348,
VLOOKUP(E348,Sheet1!A:B,2,FALSE))

In xl2007, there's an =iferror() function.

I think the syntax would be:

=iferror(VLOOKUP(E348,Sheet1!A:B,2,FALSE),e348)

 

[ryguy7272]

You can do lots of things:
http://www.mrexcel.com/forum/showthread.php?t=51
http://www.techonthenet.com/excel/formulas/vlookup.php
http://office.microsoft.com/en-us/excel/HP052093351033.aspx

Best for last:
http://contextures.com/xlFunctions02.html#IF


HTH,
Ryan---