Hi all,
I am trying to use a nested IF function but it won’t work (most likely user error) I was hoping for some direction in getting the function to work the way I want it. I am using Excel 2007.
I have two sheets of data
Sheet 1
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
Ideally I would like the counts to show up in the proper LOTU column on the second sheet by entering the equation once and being able to drag and drop. I tried this equation =IF(and(sheet1a=sheet2a2,sheet1b=sheet2b2,sheet1c=sheet2c2, sheet1d=sheet2e1), sheet1e2)
The equation had all the proper freezes in place to allow for dragging and dropping but I only ever got blank cells. When I would break out each step or a couple of steps they always worked. I'm not sure what I am doing wrong but whatever help I can get would be very much appreciated.
Thanks in advance!!!
I am trying to use a nested IF function but it won’t work (most likely user error) I was hoping for some direction in getting the function to work the way I want it. I am using Excel 2007.
I have two sheets of data
Sheet 1
a | b | c | d | e |
Site | des | rep | LOTU | count |
234 | in | 1 | x | 12 |
234 | in | 1 | y | 5 |
123 | out | 1 | y | 4 |
123 | out | 1 | z | 6 |
124 | in | 1 | w | 5 |
<tbody>
</tbody>
Sheet 2
a | b | c | d | e | f | g | h |
Site | Des | Rep | LOTU | w | x | y | z |
234 | in | 1 | |||||
123 | out | 1 | |||||
234 | in | 1 |
<tbody>
</tbody>
Ideally I would like the counts to show up in the proper LOTU column on the second sheet by entering the equation once and being able to drag and drop. I tried this equation =IF(and(sheet1a=sheet2a2,sheet1b=sheet2b2,sheet1c=sheet2c2, sheet1d=sheet2e1), sheet1e2)
The equation had all the proper freezes in place to allow for dragging and dropping but I only ever got blank cells. When I would break out each step or a couple of steps they always worked. I'm not sure what I am doing wrong but whatever help I can get would be very much appreciated.
Thanks in advance!!!