|
|
|
|
#1
10-23-2018, 02:34 AM
|
||||
|
||||
Wouldn't a simple formula like:
=VLOOKUP(C5,ATG!$B$2:$C$1000,2,FALSE) do it, where C5 is the cell containing the ID? Or if you wanted the same error message: =IFERROR(VLOOKUP(C5,ATG!$B$2:$C$35,2,FALSE),"!!!ERROR!!!") 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Hyperlink function only fully works when referring workbook is open | batchmaster | Excel | 1 | 01-26-2018 12:27 PM |
| Open Excel from MS Access and Password Protect Workbook | bconner | Excel Programming | 2 | 09-21-2017 02:32 AM |
| How to add attached excel workbook with hyperlink in the same workbook | lynchbro | Excel Programming | 0 | 02-24-2015 01:29 PM |
 Need to open an Excel WorkBook from Word VBA
|
Pierre-Hugues | Word VBA | 4 | 10-07-2013 06:27 AM |
| Unable to open Excel 97-2003 workbook | J Partridge | Excel | 1 | 11-07-2010 03:26 AM |
Windows 10 
Office 2016
Hybrid Mode