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: 134
Default How to search a column that is not the first of the table

Hi to everyone,
I have a document with a table with various columns, and i would need to
search a column which is not the first, to return the corresponding value of
the first column. It would be fine to use vlookup if the column I´m searching
were the first. Is there a function which allows me to choose the column to
search? Or does vlookup has the possibility to search in another column but
the 1st?

Thanks in advance for any help,
Antonio

 
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
Conditional Format as a MACRO Gunjani Excel Worksheet Functions 3 March 29th 06 05:22 PM
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
search value in a table and sum another column a931048 Excel Worksheet Functions 3 September 14th 05 04:50 AM
Value between 2 dates AG Excel Worksheet Functions 11 August 21st 05 05:32 PM


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