Thanks for trying but that isn't exactly what I'm looking for. In column A I have a whole series of numbers, with some of them coming up more than once. They also end up in different columns so I need the formula to say basically IF A1 (or A2, etc) has this number (5650T - there will be other numbers too that I have to put in seperate formulas) in it, add the colums for that row. I know there is a command but I'm having a hard time figuring it out. Maybe by bumping this thread somebody will know.........:)
The way you said it by using CTRL F, is the way I did it yesterday. It did work but that's very manual and time consuming.