LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 390
Default Quick lookup for data

I have a worksheet that has row headers with Employee numbers, salary, names
etc. I want to create a quick lookup that allows me to type in the employee
number and the resulting query will bring back all the data about that
specific employee. A quick lookup per employee. Can anyone help on what
function or how to do this? I am using Excel 2007

Many thanks.
 
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
data validation quick find Richard Excel Discussion (Misc queries) 9 September 22nd 07 01:44 AM
Excel 2002: Any quick way of transposing data ? Mr. Low Excel Discussion (Misc queries) 1 July 18th 07 04:14 PM
quick double-criteria lookup? robotman Excel Worksheet Functions 3 June 6th 07 10:57 PM
quick change of data OkieViking Charts and Charting in Excel 4 May 3rd 07 01:13 PM
is there a quick way to put spaces in data? jvoortman Excel Discussion (Misc queries) 8 October 15th 05 07:52 PM


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