Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cell Reference/Row Number 1
- Thread starter chkote
- Start date
SkipVought
Programmer
Hi,
Here's a way
Depending upon whether your lookup table has headings, you may have to subtract 2.
Hope this helps
Skip,
metzgsk@voughtaircraft.com
Here's a way
Code:
TheRow = Range("MyLookupTable).Row + LookupIndex - 1Hope this helps
Skip,metzgsk@voughtaircraft.com
-
1
- #3
JVFriederick
IS-IT--Management
I'm all for cheating.
Add the formula =CELL("row",L2) onto the righthand side of your lookup table and copy for as many records as needed. (L2 is just an example)
Use the same criteria as in your first vlookup, but look at the new column containing the row rumbers.
Add the formula =CELL("row",L2) onto the righthand side of your lookup table and copy for as many records as needed. (L2 is just an example)
Use the same criteria as in your first vlookup, but look at the new column containing the row rumbers.
JVFriederick
IS-IT--Management
Sorry Skip, didn't see your reply!!
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question