macro to match multiple cells against a database and select multiple cells to copy/paste

Hi,

I have an issue that for the life of me I can't solve. I might find it hard to explain but I'll my best.

I want to be able to create a macro which copies 2 cells (next to each other) and pastes those cells as values (in the same cells) over the formulas that created them as they are only needed once.

These cells however are related to a name, therefore as the cells are pasted over and the formulas are discarded, I need the macro to be able to match a cell against the name in the data base, select those cells and paste them.

Now it gets a little bit more complicated. There are 5 different cells which could have names that I want it to be able to match against.

Is it even possible to match and select more than 1 cell? I also need help with having 5 different cells to match from.

Any help would be greatly appreciated.