IF Function

  • Thread starter Thread starter MIKE
  • Start date Start date
M

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?
 
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
 
Back
Top