LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 57
Default VLookUP with multiple reference columns

Is there a way to do a Vlookup that refers to more than the first column of
the table. If not, does anyone know an easy way to connvert a table
(multiple rows and multiple columns to a table with only two columns and
multiple rows) so that I can use the vlookup funtion?
 
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
Vlookup with multiple reference Yanky Excel Worksheet Functions 1 December 11th 08 12:55 PM
Vlookup with Multiple like values in the reference column ckemtp Excel Worksheet Functions 3 July 3rd 08 03:34 AM
How do I vlookup multiple rows with same reference? Kathie C Excel Worksheet Functions 2 March 30th 08 07:09 PM
how do i reference multiple rows/columns with one function? NewUser13 New Users to Excel 1 March 4th 05 06:49 PM
how do i reference multiple rows/columns with one function? NewUser13 New Users to Excel 0 March 4th 05 06:45 PM


All times are GMT +1. The time now is 09:29 AM.

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"