Lookup with Variables
This formula needs to be in Col AR
I have tried =LOOKUP(AND(F4,"??? Total"),F4:F720,AI4:AI720)
I need to find a cell in Col F that contains the value from the same row
followed by the word "Total" and returns the value from Col AI in the same
row.
(ie. F4 = 108, F7 = 108 Total, AI7 = 7.05)
The problem is that I have multiple cells with "??? Total" where "???" is a
three digit number relating to the group above it.
Can anyone help?
~Robert
|