If(iserror(

[sburkhar]

I have the If(iserror formula below that works just fine. Is it possible to modify the formula below to say E7 OR G7?







IF(ISERROR(VLOOKUP(E7,'[2011 FIAT VLOOKUP.xls]Sheet1'!$C:$K,9,FALSE)),"",VLOOKUP(E7,'[2011 FIAT VLOOKUP.xls]Sheet1'!$C:$K,9,FALSE))

 

[Scott Huish]

Where do you want to say E7 or G7 and based on what?

 

[sburkhar]

The VLOOKUP says:
if I enter a part number in E7, give me the description as a result

What I need now:
If I enter a part number in E7 or G7, give me the description as a result.

So the only modification I need for my existing formula is:
Can it say E7 or G7 to produce a result rather than just E7.