K
kittybat
I think my follow-up to my original question got buried in the sands of time
; ) so I am re-posting as a new question. I think the solution given below
should work, but I can't quite get it to go. I need the help of an expert to
"translate" the formula to match my spreadsheet. Please see below for the
original thread:
-------------------------------------------
I think this is the right solution, but I am having trouble getting it to
work. When I remove all the extraneous columns and match my spreadsheets to
the example (ServiceDate is column B, Procedure is column C, and $Billed is
column D) on each sheet, the formula pulls the first Claim# for every line,
whether it has a match or not. If I change the formula to match the location
of my data, the formula returns 0 on each line.
Perhaps if I give you the actual columns for the existing data, there will
be less room for error on my part.
On sheet1, the columns are ServiceDate - col F, Procedure# - col G, $Billed
- col K.
On sheet2, the columns are ServiceDate - col E, Procedure# - col H, $Billed
- col K.
Can you translate the formula to match these data locations? Obviously, I'm
doing it incorrectly.
Thank you!
Kittybat
; ) so I am re-posting as a new question. I think the solution given below
should work, but I can't quite get it to go. I need the help of an expert to
"translate" the formula to match my spreadsheet. Please see below for the
original thread:
-------------------------------------------
I think this is the right solution, but I am having trouble getting it to
work. When I remove all the extraneous columns and match my spreadsheets to
the example (ServiceDate is column B, Procedure is column C, and $Billed is
column D) on each sheet, the formula pulls the first Claim# for every line,
whether it has a match or not. If I change the formula to match the location
of my data, the formula returns 0 on each line.
Perhaps if I give you the actual columns for the existing data, there will
be less room for error on my part.
On sheet1, the columns are ServiceDate - col F, Procedure# - col G, $Billed
- col K.
On sheet2, the columns are ServiceDate - col E, Procedure# - col H, $Billed
- col K.
Can you translate the formula to match these data locations? Obviously, I'm
doing it incorrectly.
Thank you!
Kittybat