error handleing with vlookup formula

[lhaitken]

i've got a formula that looks like this:
=vlookup($A2,MASTER!$A$2:$E$125,3,false)
te formula runs down the A collum pulling information. Problem i have is that other people with use this sheet and I want them to be able to add in information so i want to keep the formulas alive and just have them pull from a drop down on say A20.

however for the time being there is no info in anything past A15 and all of the lookup formulas return a #N/A since there is no valid data. How do I get this to go away?

Thanks all.

-Larry

 

[VoG]

Try

=IF(ISNA(VLOOKUP($A2,MASTER!$A$2:$E$125,3,FALSE)),"",VLOOKUP($A2,MASTER!$A$2:$E$125,3,FALSE))

 

[lhaitken]

Thanks boss. works like a charm!