Hiding rows in VLOOKUP sheet, based on null values

Hi

I have created a spreadsheet from a master using vlookup. I want to be able to hide rows which contain a null value (NA) in column B (sample attached). Is there a formula I can use which won't interfere with the vlookup or do I need to hide the rows individually? I tried filtering but that only filtered the cell and not the whole row.

As you can guess, I know very little about Excel!

Thanks in advance



test sheet.xlsx

Originally Posted by martindwilson

filtering hides the whole row

Urch. Ok thanks, can see that now. Was misled by the fact that the vlookup appears to have re-sorted some of the columns in my main sheet. Will have to go and play with that and see if I can fix that first. I may be back...

Ok, all sorted. The filter wasn't messing things up, I was! Fixed the vlookup formula and everything works. Thanks Martin