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?
Donald Trenholm
0
4
error with formula
Asmaa Abdulhamid
0
4
how to show the value in parentheses while it is assigned with a minus in the row formula
Alejandro Hasselmeyer
2
4
Resolved: Excel extending a formula down a column without me asking it to. Causes Spill error
Emmanuel Edu
1
4
No error for last formula
Manish Rochwani
0
4
percent variance formula showing error
Panagiotis Blatsas
0
4
In Questions 3 and 5 of the 4th chapter's Test, the suggested formula gives back N/A?