Fri 11 Apr 2008, 13:35Delegate Michael said...
Michael has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
VLOOKUP
I have a spread sheet using the VLOOKUP fx, however there are gaps between some of the sections in my data for organisation purposes. The problem i have is that the values section displays #N/A where the gaps are. I want the VLOOKUP formula to stay there in case i add new data but is there any adjustment to the formula i can make so that the #N/A stays blank?
Fri 11 Apr 2008, 20:59
Edited on Fri 11 Apr 2008, 21:09Trainer Pete said...
RE: VLOOKUP
Hi Michael,
Thank you for the post, This is a great question, and one that is quite easy to sort, you will need to nest your VLOOKUP inside an IF function, with a little twist called ISNA;
For example, let
