Filter. Then copy cell value

[cyr]

Hello Everyone,

I've been trying this all morning and I still haven't figured it out.
I'm still learning this whole Macro thing

Here's what I need to do:

I'm trying to set up a Macro that would copy the value in Q31 into the cell adjacent to a filtered value in Column B.

For example, Column B has a list of ID numbers. I would like to look for ID number 1099 (in column B), select the adjacent cell in the same row as ID 1099 (in column C) and paste the value stored in Cell Q31 in that cell.

Does this make sense?

 

[villy]

Try:
[C2]=IF(1099=$B:$B,$Q$31,"")