Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tbax6
 
Posts: n/a
Default matching data from column b

Have created a worksheet with a drop down box containing data from seperate
worksheet's column A and need to show the matching data in column B.
Suggestions?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default matching data from column b

=vlookup(dropdown_cell,other_sheet!A:B,2,0)

"tbax6" wrote:

Have created a worksheet with a drop down box containing data from seperate
worksheet's column A and need to show the matching data in column B.
Suggestions?

Reply
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
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
Loading Column Data with blank Rows into Data Validation Box ExcelMonkey Excel Worksheet Functions 3 October 13th 05 06:09 PM
Running total w/2 columns - Excel Anna / Ideal Excel Worksheet Functions 14 August 10th 05 04:28 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Matching data in columns Daria1977 Excel Discussion (Misc queries) 4 February 7th 05 02:24 PM


All times are GMT +1. The time now is 10:21 AM.

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

About Us

"It's about Microsoft Excel"