Microsoft Excel | Inserting a Formula in Filtered Cells

I have some very large spreadsheets, in which information I need is spread across several. I have a master spreadsheet which is "pulling" information from those various sheets using VLOOKUP. However, everytime I go to change the Table Array in the formula, then drag the formula down it overwrites the cells I filter out because they have information in the them already. I have drawn up an example for simplicity sake, see below.

Example of Spreadsheet

What I would do, is filter everything but the cells with #N/A and apply a new VLOOKUP to the next workbook, in an attempt to narrow down the list of items I don’t have information for. But when I drag from C5 to C8 the formula is changed in C6 & C7 as well.

Example of Filtered Spreadsheet

In short – how do I apply a moderately different formula between filtered cells without effecting the hidden ones? Or is there a better way to do what I want.

Super User Asked on November 26, 2021

1 Answers

One Answer

Change the formula for the whole column to something of the form:


Answered by FlexYourData on November 26, 2021

Add your own answers!

Related Questions

Dreamweaver CC 2021 bug

0  Asked on November 30, 2020 by l0ot


Driver problems with linux/config.h

0  Asked on November 30, 2020 by maxi-kirsch


Cloned SSD, how can I clone it again?

1  Asked on November 29, 2020


Access denied from apt in Linux Mint

1  Asked on November 28, 2020 by jerard-marca


How to automatize a ssh tunnel over various hosts?

1  Asked on November 28, 2020 by luis-decker


PC works for a while then dies

0  Asked on November 27, 2020


ACPI.sys high CPU usage

1  Asked on November 27, 2020 by thomas-mller


Does the HP Pavilion Dv5 1008TU support additional RAM?

0  Asked on November 27, 2020 by pigeonburger


Ask a Question

Get help from others!

© 2022 All rights reserved.