Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup top to bottom & not left to right
Hi all, is it possible to look up a number on the top of the sheet,
let's say a1, b1, c1,d1,etc.. and get the value in the last used cell of the column or must one copy and past them left to right ?? thanks in advance, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup top to bottom & not left to right
Did you try HLookup?
-Mike "Les Stout" wrote in message ... Hi all, is it possible to look up a number on the top of the sheet, let's say a1, b1, c1,d1,etc.. and get the value in the last used cell of the column or must one copy and past them left to right ?? thanks in advance, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup top to bottom & not left to right
find the column
=Match("Price",A1:Z1,0) once you have the column then Use a number larger than any in the column (assume you are looking at numbers) match(999999999999,F1:F500,1) so Putting it all together: =OFFSET($A$1,MATCH(999999,OFFSET($A$1,1,MATCH("Pri ce",$B$1:$Z$1),500,1),1),M ATCH("Price",$B$1:$Z$1)) -- Regards, Tom Ogilvy "Les Stout" wrote in message ... Hi all, is it possible to look up a number on the top of the sheet, let's say a1, b1, c1,d1,etc.. and get the value in the last used cell of the column or must one copy and past them left to right ?? thanks in advance, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup top to bottom & not left to right
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup top to bottom & not left to right
Thanks Tom, will try it in the morning.
best regards, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup top to bottom & not left to right
I guess you said a number in the first row rather than a text header, so
just replace the "Price" with a number =OFFSET($A$1,MATCH(999999,OFFSET($A$1,1,MATCH(321, $B$1:$Z$1,0),500,1),1),M ATCH(321,$B$1:$Z$1,0)) also in those two match formulas, I forgot to put the third argument in which should be a zero (0). that would be true for text or number. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... find the column =Match("Price",A1:Z1,0) once you have the column then Use a number larger than any in the column (assume you are looking at numbers) match(999999999999,F1:F500,1) so Putting it all together: =OFFSET($A$1,MATCH(999999,OFFSET($A$1,1,MATCH("Pri ce",$B$1:$Z$1),500,1),1),M ATCH("Price",$B$1:$Z$1)) -- Regards, Tom Ogilvy "Les Stout" wrote in message ... Hi all, is it possible to look up a number on the top of the sheet, let's say a1, b1, c1,d1,etc.. and get the value in the last used cell of the column or must one copy and past them left to right ?? thanks in advance, Les Stout *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate in bottom left corner | Excel Discussion (Misc queries) | |||
Why don't my filter results always appear on the bottom left? | Excel Discussion (Misc queries) | |||
Losing count on bottom left hand side when filtering - HELP!!! | Excel Discussion (Misc queries) | |||
No filter results in bottom left hand corner | Excel Discussion (Misc queries) | |||
Sorting in reverse (from right-to-left and from top-to-bottom) | Excel Discussion (Misc queries) |