AnswerBun.com

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:

=IF(ISERROR(VLOOKUP1),VLOOKUP2,VLOOKUP1)

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 AnswerBun.com. All rights reserved.