Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get Col and Row returned in an hLookup?
I have a table with the Period horizontally across the first row and then 8
lines of Budget items below the Period. I can do an hLookup and it returns the correct column but it is showing the data, (Budget) not the R1C1. i.e varGroupStart = Application.WorksheetFunction.HLookup(i, Range("Project_BudgetAllocation_FullRange"), 2, False) When I look at varGroupStart it shows "279,186". How do I get it to tell me it is H20? I need this because then I do an offset : varGroupStart.Select varGroupEnd = ActiveCell.Offset(8, i) in order to select and copy the values. Thanks for your advice. Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#N/A value is returned | Excel Worksheet Functions | |||
How to see columns from which values were not returned by HLOOKUP functions? | Excel Worksheet Functions | |||
How to see columns from which values were not returned by HLOOKUP functions? | Excel Programming | |||
#Value! Returned ? | Excel Worksheet Functions | |||
#Ref! Returned | Excel Programming |