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?
Panagiotis Blatsas
0
4
In Questions 3 and 5 of the 4th chapter's Test, the suggested formula gives back N/A?
Moataz Ahmed
0
4
Resolved: Criteria Typing in the Formula
Alejandro Hasselmeyer
2
4
Resolved: Excel extending a formula down a column without me asking it to. Causes Spill error
Tara Gholston
0
4
Resolved: What is the purpose of the LEFT function and the other similar functions?
Asmaa Abdulhamid
0
4
how to show the value in parentheses while it is assigned with a minus in the row formula
Manish Rochwani
0
4
percent variance formula showing error
Donald Trenholm
0
4
Resolved: error message "There's a problem with this formula"
Donald Trenholm
0
4
error with formula
Aniruddha Chourasia
1
2
Resolved: Doubt about Formula syntax
Asmaa Abdulhamid
0
2
Why does the net income have opposite signs for the same values??