Dlookup - how to match value in a table?

[behedwin]

Hi

I want to make an if statement that looks for a matching value in a table´s column.

Table name: table1
column: name

I have a value being held in a variable called "username" (dont know if im explaining this correctly)
If i do a code

msgbox username

i do get the expected value i want... now i want to look if that value is stored in a table in a column.

If table1,column=name = username then
msgbox "value found in table"
else
msgbox "value not found in table"
end if

from what i have read i should do a DLookup line.... but i dont know how to write that.
Anyone able to help me?

 

[steve the fish]

You want to use it in excel table? You could like this:

tName = "table1"
cName = "name"
uName = "steve"

If IsError(Application.Match(uName, Sheets("Sheet1").ListObjects(tName).ListColumns(cName).Range, 0)) Then
    MsgBox "Value doesnt exist"
Else
    MsgBox "Value does exist"
End If

 

[behedwin]

****. This is in access. I posted this in the wrong section.