Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP Help Needed
I've been working on updating a spreadsheet off and on for the last two
months and can't get my VLOOKUP to work properly. Last month I asked for help here and got a little direction, but the problem isn't fully resolved and I'm about to give up completely. My columns are laid out like this: Company Name|City|State|Req.State|Sep08|Oct08|Nov08|Dec08| YTD Total Each row is for a different company, though there may be three rows with the same company name and different City, State, and/or Req.States -like this: Company City State Req. St. Sep Oct Nov Jones Harbor LLC Jackson MS MS 100 Jones Harbor LLC Jackson MS MS 100 Jones Harbor LLC Tulsa OK TX 200 Jones Harbor LLC Tulsa OK TX 200 Jones Harbor LLC Tulsa OK MS 300 English Brakes Inc. Austin TX TX 100 English Brakes Inc. Atlanta GA KY 100 English Brakes Inc. Atlanta GA KY 100 English Brakes Inc. Atlanta GA WY 175 English Brakes Inc. Houston TX TX 500 But I need it to look like this: Company City State Req. St. Sep Oct Nov Jones Harbor LLC Jackson MS MS 100 100 Jones Harbor LLC Tulsa OK TX 200 200 Jones Harbor LLC Tulsa OK MS 300 English Brakes Inc. Austin TX TX 100 English Brakes Inc. Atlanta GA KY 100 100 English Brakes Inc. Atlanta GA WY 175 English Brakes Inc. Houston TX TX 500 I need to VLOOKUP the Company AND City AND State AND Req.State and if they match, pull the revenue up to the same row apprpriate monthly column. Is this possible? Thanks so much for your help on this. It will be a true timesaver if I can get this to work properly. Debbi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Help Needed | Excel Discussion (Misc queries) | |||
VLOOKUP help needed PLEASE... | Excel Worksheet Functions | |||
Help needed on VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup Help Needed | Excel Discussion (Misc queries) | |||
VLOOKUP help needed! | Excel Worksheet Functions |