If vlookup is false, leave blank and not #N/A

spectraflame · Mar 30th, 2004, 06:11 PM

I have the following formula that is looking up a date in a list of dates. If the date is found, the contents of the adjacent cells is returned.

=VLOOKUP($G$4,SETUP!J3:K32,2,0)

What can I modifed so that if the result is not found, the cell is left blank and not show #N/A?

Thanks,
Matthew

just_jon · Mar 30th, 2004, 06:12 PM

For a thoughtful commentary on how to avoid the #N/A return, see Aladin's posting here.

spectraflame · Mar 30th, 2004, 06:17 PM

Thanks Jon and Aladin.

That is perfect.

Matthew

Mar 30th, 2004, 06:11 PM	#1
spectraflame Join Date: Dec 2002 Location: Missouri Posts: 594	If vlookup is false, leave blank and not #N/A I have the following formula that is looking up a date in a list of dates. If the date is found, the contents of the adjacent cells is returned. =VLOOKUP($G$4,SETUP!J3:K32,2,0) What can I modifed so that if the result is not found, the cell is left blank and not show #N/A? Thanks, Matthew

Mar 30th, 2004, 06:12 PM	#2
just_jon MrExcel MVP Join Date: Sep 2002 Location: Alabama/State of Disarray Posts: 10,473	Re: If vlookup is false, leave blank and not #N/A For a thoughtful commentary on how to avoid the #N/A return, see Aladin's posting here. __________________ just_jon Book of the Month: I'm Not Really an MVP, I Just Play One on TV [j. jon, 2004]

Mar 30th, 2004, 06:17 PM	#3
spectraflame Join Date: Dec 2002 Location: Missouri Posts: 594	Re: If vlookup is false, leave blank and not #N/A Thanks Jon and Aladin. That is perfect. Matthew

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode