Look UP or fill in

G

gfj

I have two sheets of data
Sheet 1 1-9999
sheet 2 1-2800 (from 1-9999)
I want to combine the sheets where if there is data in Sheet 2 the remaing
numbers will eithe be lfet bland or 0 added
Exampe of data in two rows
Sheeet 1 Sheet2
OCN Class OCN Class
146 3 147 Blank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Publisher is filling blank lines with data 2
Looking up a Cell and returning correspong Cell value 0
IF statement with multiple VLOOKUPs 0
Help - hiding multiple sets of rows based on two different cells 2
Code copies twice...? 13
Macro beginner help with making tables 1
copy data from master sheet 6
Creating an attendance sheet EXCEL 0

Top