Good afternoon,
I need some assistance on finding a formula! Jumping straight to the point, here is my predicament:
<tbody>
</tbody>
I am trying to look up a value under 0001 (D2), 0002 (E2), etc. but it also has to look at Customer # to pick the correct value. For example, customer x will have info under 0001 and 0004 on different cells (same column) but I need those values to be posted with a formula..
Any help would be appreciated!!
I need some assistance on finding a formula! Jumping straight to the point, here is my predicament:
Customer # | Customer Name | Master Price Level | 0001 | 0002 | 0003 | 0004 | 0005 |
x | apple | 1 | |||||
y | ibm | 2 | |||||
z | dell | 3 |
<tbody>
</tbody>
I am trying to look up a value under 0001 (D2), 0002 (E2), etc. but it also has to look at Customer # to pick the correct value. For example, customer x will have info under 0001 and 0004 on different cells (same column) but I need those values to be posted with a formula..
Any help would be appreciated!!
Last edited: