Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup & hlookup
Hi
How can I make exel return a call value which is an intersection of a vlookup and a hlookup? eg: if the hlookup looks across the columns looking for a prescribed value, ie a particular month and year amongst 5 years (60 columns - 5 x 12months) worth of months. Then the vlookup goes down the column looking for the intersection of that column and the row which coincides with the vlookup value. Thanks for your help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup & hlookup
One way:
Find the row with VLOOKUP then find the column with MATCH. Here's a screencap: http://img130.imageshack.us/img130/4610/lookupwt1.jpg Biff "Aitchy" wrote in message ... Hi How can I make exel return a call value which is an intersection of a vlookup and a hlookup? eg: if the hlookup looks across the columns looking for a prescribed value, ie a particular month and year amongst 5 years (60 columns - 5 x 12months) worth of months. Then the vlookup goes down the column looking for the intersection of that column and the row which coincides with the vlookup value. Thanks for your help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup & hlookup
Outstanding!!
Thanks :-) "T. Valko" wrote: One way: Find the row with VLOOKUP then find the column with MATCH. Here's a screencap: http://img130.imageshack.us/img130/4610/lookupwt1.jpg Biff "Aitchy" wrote in message ... Hi How can I make exel return a call value which is an intersection of a vlookup and a hlookup? eg: if the hlookup looks across the columns looking for a prescribed value, ie a particular month and year amongst 5 years (60 columns - 5 x 12months) worth of months. Then the vlookup goes down the column looking for the intersection of that column and the row which coincides with the vlookup value. Thanks for your help |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup & hlookup
You're welcome. Thanks for the feedback!
Biff "Aitchy" wrote in message ... Outstanding!! Thanks :-) "T. Valko" wrote: One way: Find the row with VLOOKUP then find the column with MATCH. Here's a screencap: http://img130.imageshack.us/img130/4610/lookupwt1.jpg Biff "Aitchy" wrote in message ... Hi How can I make exel return a call value which is an intersection of a vlookup and a hlookup? eg: if the hlookup looks across the columns looking for a prescribed value, ie a particular month and year amongst 5 years (60 columns - 5 x 12months) worth of months. Then the vlookup goes down the column looking for the intersection of that column and the row which coincides with the vlookup value. Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hlookup & vlookup together | Excel Discussion (Misc queries) | |||
vlookup and hlookup | Excel Worksheet Functions | |||
can i use vlookup and hlookup together | Excel Discussion (Misc queries) | |||
VLookup & HLookup | Excel Discussion (Misc queries) | |||
Vlookup and Hlookup | Excel Worksheet Functions |