Microsoft Office Forums Maybe I need help with "Lookups"?

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-06-2005, 03:11 PM
garry05 garry05 is offline
Novice
Maybe I need help with "Lookups"?
 
Join Date: Dec 2005
Posts: 1
garry05
Default Maybe I need help with "Lookups"?

Hi all...a newbie here.



I'm okay with many Excel functions, but I don't go too deep: Can't do macros, lookups, that sort of thing.

Here's my dilemma: Sheet-2 has a list of 10 aircraft, and the goal is to accumulate the hours-flown for each aircraft...Column A is the aircraft# (1-10), B is the aircraft name, C is the accumulated hours-flown. Keeping it simple, let's say that A1=1, B1=Cessna, and C1=26.5

Now, back to Sheet-1: Someone flew the Cessna for 2 hours...in A1 I'll enter 1 for the aircraft#, and in B1 I'll enter "2" for the hours-flown. Now Sheet-2 C1=28.5, or maybe some cell on Sheet-1, for all I care.

I can, of course, just go to Sheet 2, find the right column/cell and update manually, but this is duplicated effort that leaves way too much room for human error.

If anyone can help with this, it would be much appreciated...let me know if you want a copy of the existing spreadsheet.

Thanks,
Garry (garry@lewisaire.com)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maybe I need help with "Lookups"? MYOB and "Item.Send error" Outlook message peter_lambros Outlook 1 12-06-2008 08:24 AM
"IF" "THEN" statements in Macros mfgeng_iss Misc 0 10-04-2007 07:31 AM
How 2 retain MSOffice "Upgraded" on full restore misterbobthetomato Office 0 02-04-2007 11:08 AM
"open" or "open using" option not availa ccd Outlook 0 09-22-2006 01:23 AM


All times are GMT -7. The time now is 10:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft