Simply reading a value from a specific cell from a sheet from a workbook (opened workbook)
The simple version of VLookup, works like Index or VLookup+Match
Index: Gets the value from cell giving row+Col
VLookup: Searches for a value in certain col, and/or searches for a header in certain row, then get the value of the intersection for that col, that row.
Can have sheet name and/or workbook name
any given combination can be used
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydev.net
Linkedin Login
Optional ColumnName, Optional RowNumber, Optional Search4ID, Optional InColumnName, Optional Search4Header, Optional InRowNumber, Optional Shee, Optional Wb
SimpleLookup("A", 3) ' Cell A3 in this workbook active sheet
SimpleLookup(, 14, , , "Date", 4) ' Row 14 + Column where we find Date in row 4
SimpleLookup(, 14, , , "Date", 4) ' Row 14 + Column where we find Date in row 4
Views 3,116
Downloads 1,330
CodeID
DB ID
