I am having problems with IF THEN statements in excel and need some expert help.
I'd like to search a a particular column for a specific item, then if the item matches a cell from the worksheet, input a number from a corresponding row to that column from the second worksheet.
Let me provide an example.
I have two worksheets in the file, Projection and 2008 #s. Each worksheet has the same titles to first columns, Name, PA, HR. The worksheet 2008 #s has the following info in rows 2, 3, and 4: Sizemore, 700, 30 // Braun, 600, 40 // Pujols, 625, 45. In the Projection worksheet, cell a2, I have the info Braun. In cell b2, I would like a formula to search all of the column Name in worksheet 2008 #s, and if it matches cell a2, input the corresponding info from the PA column in the 2008 #s worksheet into cell b2.
Here's the formula I currently have (which doesn't work):
=if(A2='2008 #s'!A:A,'2008 #s'!B1:B170,0)
There is a problem with the middle item, the "value if true" part of the formula, and I have no idea how to fix it. Any help would be greatly appreciated.
PS - I probably insane for doing this in excel and not access, but I have no idea how to use access.
In my fridge: Founders Kentucky Breakfast Stout (KBS), Central Waters Peruvian Morning, Bell's Batch 10,000, Dale's Pale Ale, Capital Brewery Amber, New Glarus Moon Man, and Guinness.
Major League Manager
Joined: 7 May 2004
Bases this season: 0
Home Cafe: Baseball
Location: Finally back home. A sweet 15 mi from Miller Park.