Jasmin Zamora
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?
Sali Sali
1
6
Hi. Are you using some key combination to put the $ sign in your formula?
Manish Rochwani
0
4
percent variance formula showing error
Tara Gholston
0
4
Resolved: What is the purpose of the LEFT function and the other similar functions?
Panagiotis Blatsas
0
4
In Questions 3 and 5 of the 4th chapter's Test, the suggested formula gives back N/A?
Donald Trenholm
0
4
Resolved: error message "There's a problem with this formula"
Donald Trenholm
0
4
error with formula
Emmanuel Edu
1
4
No error for last formula
Matt Gayle
0
4
Adding named ranges actually works!
Asmaa Abdulhamid
0
4
how to show the value in parentheses while it is assigned with a minus in the row formula
Nguhemen Tingir
1
4
Resolved: Formula not working
Alejandro Hasselmeyer
2
4
Resolved: Excel extending a formula down a column without me asking it to. Causes Spill error