| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup and offset at the same time?
Hi,
I am not sure how to accomplish this task. I have multiple columns of data. I am locating a value in a column (F) on the right using vlookup to find the max value of the data in this column. Now I wnat to find the corresponding data that is in the cell in column (A) that is in the same row as the data I found using my vlookup. I have tried a few ideas, none seem to work - I have a feeling this mis much easier than I think. Thanks TedT |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup and offset at the same time?
I've used MATCH and INDEX for this type of thing in the past. Unfortunately,
Excel is tied up on this machine right now, so can't give any more details. -- HTH, Barb Reinhardt "TedT" wrote: Hi, I am not sure how to accomplish this task. I have multiple columns of data. I am locating a value in a column (F) on the right using vlookup to find the max value of the data in this column. Now I wnat to find the corresponding data that is in the cell in column (A) that is in the same row as the data I found using my vlookup. I have tried a few ideas, none seem to work - I have a feeling this mis much easier than I think. Thanks TedT |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup and offset at the same time?
Try this:
=INDEX(A:A,MATCH(MAX(F:F),F:F,0)) -- Biff Microsoft Excel MVP "Barb Reinhardt" wrote in message ... I've used MATCH and INDEX for this type of thing in the past. Unfortunately, Excel is tied up on this machine right now, so can't give any more details. -- HTH, Barb Reinhardt "TedT" wrote: Hi, I am not sure how to accomplish this task. I have multiple columns of data. I am locating a value in a column (F) on the right using vlookup to find the max value of the data in this column. Now I wnat to find the corresponding data that is in the cell in column (A) that is in the same row as the data I found using my vlookup. I have tried a few ideas, none seem to work - I have a feeling this mis much easier than I think. Thanks TedT |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup and offset at the same time?
Maybe you're trying to do something like this, in say G1:
=INDEX(A:A,MATCH(MAX(F:F),F:F,0)) G1 returns the value in col A corresponding to the max in col F. If there's ties in the maximum values in col F, it'll return only the the value corresponding to the 1st maximum (the one higher up) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "TedT" wrote: Hi, I am not sure how to accomplish this task. I have multiple columns of data. I am locating a value in a column (F) on the right using vlookup to find the max value of the data in this column. Now I wnat to find the corresponding data that is in the cell in column (A) that is in the same row as the data I found using my vlookup. I have tried a few ideas, none seem to work - I have a feeling this mis much easier than I think. Thanks TedT |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup and offset at the same time?
Thanks for the help, I got it working.
TedT "Max" wrote: Maybe you're trying to do something like this, in say G1: =INDEX(A:A,MATCH(MAX(F:F),F:F,0)) G1 returns the value in col A corresponding to the max in col F. If there's ties in the maximum values in col F, it'll return only the the value corresponding to the 1st maximum (the one higher up) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "TedT" wrote: Hi, I am not sure how to accomplish this task. I have multiple columns of data. I am locating a value in a column (F) on the right using vlookup to find the max value of the data in this column. Now I wnat to find the corresponding data that is in the cell in column (A) that is in the same row as the data I found using my vlookup. I have tried a few ideas, none seem to work - I have a feeling this mis much easier than I think. Thanks TedT |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup and offset at the same time?
Worked fine,
Thank you "T. Valko" wrote: Try this: =INDEX(A:A,MATCH(MAX(F:F),F:F,0)) -- Biff Microsoft Excel MVP "Barb Reinhardt" wrote in message ... I've used MATCH and INDEX for this type of thing in the past. Unfortunately, Excel is tied up on this machine right now, so can't give any more details. -- HTH, Barb Reinhardt "TedT" wrote: Hi, I am not sure how to accomplish this task. I have multiple columns of data. I am locating a value in a column (F) on the right using vlookup to find the max value of the data in this column. Now I wnat to find the corresponding data that is in the cell in column (A) that is in the same row as the data I found using my vlookup. I have tried a few ideas, none seem to work - I have a feeling this mis much easier than I think. Thanks TedT |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup and offset at the same time?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "TedT" wrote in message ... Worked fine, Thank you "T. Valko" wrote: Try this: =INDEX(A:A,MATCH(MAX(F:F),F:F,0)) -- Biff Microsoft Excel MVP "Barb Reinhardt" wrote in message ... I've used MATCH and INDEX for this type of thing in the past. Unfortunately, Excel is tied up on this machine right now, so can't give any more details. -- HTH, Barb Reinhardt "TedT" wrote: Hi, I am not sure how to accomplish this task. I have multiple columns of data. I am locating a value in a column (F) on the right using vlookup to find the max value of the data in this column. Now I wnat to find the corresponding data that is in the cell in column (A) that is in the same row as the data I found using my vlookup. I have tried a few ideas, none seem to work - I have a feeling this mis much easier than I think. Thanks TedT |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup and offset at the same time?
Welcome, Ted. Take a moment to press the "Yes" button below to the question:
"Was this post helpful to you?" from where you're reading this. It'll ensure a longer shelf life to this thread for the general benefit of other readers. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "TedT" wrote: Thanks for the help, I got it working. TedT |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup and offset at the same time?
Take a moment to press the "Yes" button below
to the question: "Was this post helpful to you?" Done! -- Biff Microsoft Excel MVP "Max" wrote in message ... Welcome, Ted. Take a moment to press the "Yes" button below to the question: "Was this post helpful to you?" from where you're reading this. It'll ensure a longer shelf life to this thread for the general benefit of other readers. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "TedT" wrote: Thanks for the help, I got it working. TedT |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup and offset at the same time?
Done!
Muchas gracias`, amigo! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup, then offset? | Excel Worksheet Functions | |||
| Lookup with offset | Excel Worksheet Functions | |||
| Lookup and offset | Excel Discussion (Misc queries) | |||
| Help with Offset/Lookup | Excel Worksheet Functions | |||
| lookup with offset? | Excel Worksheet Functions | |||
Linear Mode
