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?

1

4

No error for last formula

0

4

Resolved: Criteria Typing in the Formula

Nguhemen Tingir

1

4

Resolved: Formula not working

Donald Trenholm

0

4

Resolved: error message "There's a problem with this formula"

Asmaa Abdulhamid

0

4

how to show the value in parentheses while it is assigned with a minus in the row formula

0

4

Resolved: What is the purpose of the LEFT function and the other similar functions?