|
|
#13
07-06-2023, 03:00 AM
|
|||
|
|||
thanks p45cal for quick reply. it seems after i fixed them its working again. i dont know how it gets #VALUE! errors.
those #VALUE! comes from an formula mentioned in this thread. if click those cell without corresponding files opened. this error occurs. after open this files, errors fix themself automatically. Also row range needs to be increased to 200 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Vlookup help | mance006 | Excel | 3 | 08-05-2021 03:19 AM |
| Tell me which place the vlookup was successful (within a nested vlookup) | Izzii0x | Excel | 2 | 07-18-2019 10:29 PM |
| How can I return Vlookup only if Specific Criteria is met in 1 column of the Vlookup Array | EcommDOC | Excel | 7 | 01-22-2018 11:00 AM |
| something like VLOOKUP | hanvyj | Excel | 4 | 03-13-2012 09:03 AM |
| Vlookup | Karen615 | Excel | 4 | 09-12-2011 02:30 PM |
VLOOKUP with max value
Windows 10 
Office 2019
Threaded Mode