Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to search a column that is not the first of the table
Try using the =INDEX - MATCH formula With that you can choose which column
to return the value from - SEE this example http://support.microsoft.com/kb/214142 or even this one simplifies it even more "Antonio" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to search a column that is not the first of the table
Try using the =INDEX - MATCH formula With that you can choose which column
to return the value from - SEE this example http://support.microsoft.com/kb/214142 or even this one simplifies it even more "Antonio" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to search a column that is not the first of the table
http://www.mrexcel.com/tip021.shtml
sorry about that forgot to paste the url into it. "JLeoni" wrote: Try using the =INDEX - MATCH formula With that you can choose which column to return the value from - SEE this example http://support.microsoft.com/kb/214142 or even this one simplifies it even more "Antonio" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to search a column that is not the first of the table
Thanks a lot! Now I have understood the combined use of INDEX-MATCH. Powerful and it works! If I understand well: INDEX(TAB;MATCH(REF;COL_N_OF_TAB;FALSE);1) Search the reference REF in Nth column of table TAB and gives the value of the cell in column 1 and row corresponding to the position of REF in column N. Which is just what I needed. And mo INDEX(TAB;MATCH(REF;COL_1_TAB;FALSE);N)=VLOOKUP(RE F;TAB;N;FALSE) The problem is that in vlookup you can´t choose the column number to search:it´s always 1. Unfortunately, I had already moved the column to the first place (which caused me a lot of trouble because of a lot of references in other formulas...). : ( Cheers, Antonio "JLeoni" escreveu: http://www.mrexcel.com/tip021.shtml sorry about that forgot to paste the url into it. "JLeoni" wrote: Try using the =INDEX - MATCH formula With that you can choose which column to return the value from - SEE this example http://support.microsoft.com/kb/214142 or even this one simplifies it even more "Antonio" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
search value in a table and sum another column | Excel Worksheet Functions | |||
Value between 2 dates | Excel Worksheet Functions |