LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 21
Default Find a row give me a column

Hello Lovely Excel People (flattery works sometimes)
OK so I have a spreadsheet (I know amazing)
With lots of data.
Column A is period so 200908 is August 2009
Column D is a Customer Number.
Column Y I want to be Column T minus Colum T of Customer in "D" in Row A -1
So for instance we are using line 3500
in column Y it would be D3500= 12345
Find 12345 in the spread sheet where Column A = A3500-1

OK anyone have any ideas or any questions to make this actually make sense?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
divide column(x) by column(y) to give column(x/y) in excel? James New Users to Excel 2 April 24th 23 11:46 AM
Trying to find Matches and Give a Result cheryl Excel Worksheet Functions 5 July 26th 07 09:06 PM
How to make LOOKUP give zero if it can't find the lookup_value? Dmitry Kopnichev Links and Linking in Excel 3 October 12th 05 09:47 PM
How to make LOOKUP give zero if it can't find the lookup_value? Dmitry Kopnichev Excel Worksheet Functions 3 October 12th 05 09:47 PM
calculate which cells in column A will give me the total of column Ken Excel Worksheet Functions 4 January 6th 05 06:25 AM


All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"