Attached is my worksheet. I need help adding one additional lookup in Detail worksheet, column K (rate). If no rate is found using current criteria, lookup value in Detail worksheet column G (Team) and find it on the Project worksheet in column D (Team) and return the value in column E (rate)
Does this make sense?
Thanks for your help
Bookmarks