Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup, several tables, one sheet
Hi All,
I've used the Vlookup, Match and Offset to find and format the font of a value in a cell in one table. This all works well on one table, when the value exists in the table. If the value I'm looking for does not exist, it displays the #N/A in the cell holding the value, so I get a runtime error 13, type mismatch. The OnError handles this just fine when used on one table only. The Problem: The Worksheet is updated on a monthly basis with changing ascending values that stop and reset at 1,000,000, some tables have it and other do not. There are seven tables, having equal amounts of rows, and when I try to move from the first table to the second, I get a duplicate error for the OnError command. How do I handle this error when the value doesn't exist? Eventually this 1,000,000 value will appear in each table. Is there a value associated with the #N/A that I can use in an IF statement? Thanks for any light you can shed on the subject, Al |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup tables | Excel Discussion (Misc queries) | |||
VLookup Tables | Excel Worksheet Functions | |||
vlookup on 3 different tables - please HELP | Excel Worksheet Functions | |||
Can you do two Vlookup tables in one sheet? | Excel Discussion (Misc queries) | |||
VLookUp / 2 Tables | Excel Discussion (Misc queries) |