Function

[smallfella]

Hi,
I have the following formula and would like to add the ISERROR function.
Could someone please post a reply with the amended formula?
tia

[davesexcel]

Lets see the formula, oh never mind , here's one example

=IF(ISERROR(VLOOKUP(C9,A2:B26,2,FALSE)),"No Such Item",VLOOKUP(C9,A2:B26,2,FALSE))


so what it is really saying is if the formula shows an error then show "No such Item"
else do the lookup

[smallfella]

Wow I've made a few blunders in my time, this one takes the biscuit.
Here's the formula:
=VLOOKUP(E3,$B$3:$D$11,MATCH($F$1,$B:$D$11,0),FALSE)

[davesexcel]

what does this formula say when you use it??

here's an example with vlookup and isserror

[smallfella]

The formula is one I have found in the Microsoft Office Assistance and pretty much does what I want. It states that using ISERROR will deal with missing data and will give a blank cell if required rather than an error value, as there will be a number of spaces in my lists I figured this would be a good idea, I just can't work out where to put the additional function.



Practice1.zip

[davesexcel]

This is all you need
=VLOOKUP(E3,$B$3:$C$11,2,0)

SO this is the formula with the iserror
=IF(ISERROR(VLOOKUP(E3,$B$3:$C$11,2,0)),"",(VLOOKUP(E3,$B$3:$C$11,2,0)))