Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using hlookup to reference a column in a vlookup formula?
i am looking to have a specific spreadsheet reference a second sheet that is
variable daily in both rows and columns...a vlookup takes care of the rows, but since the number of columns and/or column order may change, i cannot hardcode the column index number in the vlookup formula. i thought i could use a vlookup formula where the column referenced is based on a column and hlookup function...i tried the following, but received an error message: =vlookup(a2,myrange,column(hlookup(b1,myrange,1,fa lse)),false) is there a way to accomplish this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column reference in Vlookup formula | Excel Worksheet Functions | |||
Can you use HLOOKUP inside VLOOKUP to tell it what column 2 return | Excel Worksheet Functions | |||
vlookup and hlookup in the same formula | Excel Discussion (Misc queries) | |||
Vlookup/hlookup without using row or column numbers | Excel Worksheet Functions | |||
formula using both vlookup & hlookup | Excel Worksheet Functions |