IF Function

[MIKE]

I am trying to take a column of numbers and move each one
of them to another location if they match a number on
another worksheet (master list). For example, if B2 is
25763 and 25763 is somewhere in the master list, then I
would like that number to be pasted into a different
worksheet. The IF function doesn't work because it won't
accept a range. Is there another function I can try?

 

[EZ Money]

One way: Data>Filter>Autofilter and copy/paste from there.

 

[Sabre]

A bit of code might be the answer? Well I'm not familiar with all the
built-in functions (maybe there is something ... they're getting trickier
every release). But code is good if the task is repetitive and ongoing, If
you need help, email me.

Graeme