Based on the selection from the (Select Acft) drop down, search for matching info in Column A and reference the Condition in Column B and associated hours in Column C to return totals for those Conditions in E3 thru I3.
Example: Selecting UH-60A from the drop down would result in the following values...
E3: 2.0
F3: 4.0
G3: 6.0
H3: 4.0
I3: 0.0
Thanks in advance!
Enter formula in E3 and pull to the right
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks