Maybe this was addressed before, but I don't know. I have a table of job numbers, a lit for residential and a list for commercial. I need a formula/macro etc that if cell a1 - residentail & Cell b1 = job the next available residential number will go into c1. Same for commercial. How do i do that easily?