Lookup a header in a table - Excel 2003
Closed
StripeyChalk
-
Apr 6, 2010 at 02:09 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 6, 2010 at 09:21 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 6, 2010 at 09:21 PM
Related:
- Lookup a header in a table - Excel 2003
- School time table software free download full version - Download - Organisation and teamwork
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
- Dd-mm-yyyy format in excel - Guide
- Excel free download - Download - Spreadsheets
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Apr 6, 2010 at 09:21 PM
Apr 6, 2010 at 09:21 PM
I am not clear what you want.
try this macro and see whether you get what you want.
try this macro and see whether you get what you want.
Sub test() Dim x As String, cfind As Range, y As String Dim cfind1 As Range x = Worksheets("sheet1").Range("C3") Worksheets("sheet2").Activate Set cfind = Columns("d:d").Cells.Find(what:=x, lookat:=xlWhole) y = Cells(2, cfind.Column) Set cfind1 = Worksheets("sheet1").Cells.Find(what:=y, lookat:=xlWhole) MsgBox cfind1.Address End Sub