Using F9 to shows the values of a formula

[lovetofly32]

Is there a way to use F9 to show the values of a formula across multiple formulas efficiently?

For example, =COUNTIF(H2,D3)=0 is a formula that references a list (H2) and then returns true/false if the cell I'm checking (D3) is in that list. H2 however represents a formula that concatenates several strings, which when combined represent the name of the list I'm referencing. I need the formula to show =COUNTIF(LIST1,D3)=0 instead of =COUNTIF(H2,D3)=0. The only way i know to do that is by highlighting "H2", select F9, and then remove the quotes from the value.

I need to automate this process. Thanks for any advice!!

[Ace_XL]

Why not change formula itself to

=COUNTIF(LIST1,D3)=0

[lovetofly32]

Why not change formula itself to

=COUNTIF(LIST1,D3)=0

In reality i have 52 different lists. These lists represent criteria that I am comparing across hundreds of possibilities. So i need a way of automating the referencing of a specific list from the universe of the 52, based on criteria within those hundreds of possibilities.

[Jonmo1]

Perhaps

=COUNTIF(INDIRECT(H2),D3)

[lovetofly32]

Perhaps

=COUNTIF(INDIRECT(H2),D3)

I assume you meant "=COUNTIF(INDIRECT(H2,FALSE),D3)"?? Either way that worked!! Thank you!

[Jonmo1]

No, I meant it as I posted it..
Not sure what difference the FALSE would make, that dictates whether it uses A1 style or R1C1 Style
If H2 contains the name of a Named Range, then it doesn't matter if that option is true or false.

Anyway, glad it worked out.

[lovetofly32]

No, I meant it as I posted it..
Not sure what difference the FALSE would make, that dictates whether it uses A1 style or R1C1 Style
If H2 contains the name of a Named Range, then it doesn't matter if that option is true or false.

Anyway, glad it worked out.

You're right. I went back and removed the FALSE syntax and it worked that way too. Thanks again! Spent half the day on this one.

[Jonmo1]

You're welcome.