I wanted to search a value in my spreadsheet using VBA.
I tried to use VLOOKUP and DLOOKUP, but I got compile error "sub or
function not defined"

The code is like following code

iStudent = DLOOKUP("[FIRST SEMI]", "NPARAMETER", "[SHEET NAME]" = "STUDENT
NUMBER")

iStudent = VLookup("STUDENT NUMBER", "NPARAMETER", False)

Are there any other way to search a value from spreadsheet and return a
value from other column?

Any infromation is great appreciated,