I am desperate for an answer. Here is an example of what I have:
Column E Column F
FOODSERVICE OTHER
#N/A #N/A
FOODSERVICE Check
#N/A #N/A
#N/A #N/A
MInt OTHER
#N/A #N/A
#N/A #N/A
I have a vlookup that looks up two other spreadsheets and brings in info. I get an #N/A which makes sense, but what I need it to do is for every title change I need the #N/A to be replaced with the title above it.
The problem is that it is a long list and titles change. I thought maybe there is some vba code that can help me.
Thanks everyone