| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I write a vlookup function within an iserror function so t.
|
|
#2
|
|||
|
|||
|
Hi
please post a short description in the subject line and the question in the message body as it gets truncated in the subject line taking a guess as to what you're after try =IF(ISNA(VLOOKUP(the formula)),"",VLOOKUP(the formula)) however please post back if this isn't what you're after Cheers julieD "JBLeeds" wrote in message ... |
|
#3
|
|||
|
|||
|
=IF(ISERROR(VLOOUP...),"",VLOOKUP...)
as a guess at what you are asking -- HTH RP (remove nothere from the email address if mailing direct) "JBLeeds" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non-sequential VLOOKUP function -OR- sequential sort of web query | Excel Worksheet Functions | |||
| I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions | |||
| carrying a hyper link when using the vlookup function | Excel Worksheet Functions | |||
| carrying a hyper link when using the vlookup function | Excel Worksheet Functions | |||
| Regarding IF function or vLOOKUP function | Excel Worksheet Functions | |||
Linear Mode
