Hi Steve
what is 'workbookfunction' :-)
you probably meant
Range("A1").value =
application.VLookUP(Range("A2").value,Range("M1:P5 "),2,0)

(also clearing some typos and adding the 4th parameter to vlookup)


--
Regards
Frank Kabel
Frankfurt, Germany


steveB wrote:
Range("A1") = Workbookfunction(VLookUP(Range("A2",Range("M1:P5") ,2))

Just substitute the cell and range settings.
You may want to use

Range("A1").Value=.............

hth

"hey" wrote in message
...
I would like to see the writing for a macro that looks up a value in
a
table then copies it and pastes it to a certain cell.

Thanks