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
--

steveB

(Remove 'NOSPAM' from email address if contacting me direct)


"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