Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
EC EC is offline
external usenet poster
 
Posts: 12
Default lookups

All,

I have a worksheet full of data that is sorted by account number. I wasnt
to write a lookup up formula that will look at the 'data tab' and if the
account num,ber matches a certain account, then it will pull all of the
information for that account number. For example, in colunm A there are a
list of account numbers and from columns b thru z there is info. I want to
write a formula that will lookup up the account number I want from column A
and if it matches, give me all of the other info.

Any and all help is greatly appreciated.

Eric
 
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
Help with Crazy Lookups rkhuntjr Excel Worksheet Functions 2 August 21st 06 03:50 AM
CAN DATES BE USED IN LOOKUPS? Riasworld Excel Discussion (Misc queries) 1 February 21st 06 01:12 PM
Maybe I need help with Lookups?? garry05 Excel Worksheet Functions 4 December 8th 05 02:26 AM
Q: Using lookups to normalize a database? Charles W. Stricklin Excel Discussion (Misc queries) 2 September 2nd 05 02:24 PM
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. Mr Wiffy Excel Worksheet Functions 2 May 16th 05 04:29 AM


All times are GMT +1. The time now is 09:21 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"