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?

Manish Rochwani

0

4

percent variance formula showing error

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

1

4

No error for last formula

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