Posted to microsoft.public.excel.programming
|
|
if-then-else in VLOOKUP function
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/ex...093351033.aspx
Best for last:
http://contextures.com/xlFunctions02.html#IF
HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"Himansu" wrote:
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.
--
Thanks,
Himansu
|