Follow this topic

Posted on:

09 Nov 2023

0

Whats the purpose of adding the dollar signs in the formula?

in Introduction to Excel / Excel's Lookup Functions: VLOOKUP & HLOOKUP made easy

I wrote the formula without the dollar signs and it worked fine.

0 answers ( 0 marked as helpful)

Submit an answer

related questions

Panagiotis Blatsas

0

12

Index and Match exercise tried the exact formula yet all results are N/A?

1

6

Hi. Are you using some key combination to put the $ sign in your formula?

Alejandro Hasselmeyer

2

4

Resolved: Excel extending a formula down a column without me asking it to. Causes Spill error

Manish Rochwani

0

4

percent variance formula showing error

1

4

No error for last formula

Panagiotis Blatsas

0

4

In Questions 3 and 5 of the 4th chapter's Test, the suggested formula gives back N/A?

Nguhemen Tingir

1

4

Resolved: Formula not working

0

4

Resolved: Criteria Typing in the Formula