i'm using vlookup to match data. Now the problem is: i have 3 column as TABLE_ARRAY. Now when i enter the lookup_value i want it to search first column 1 then if not matches then column 2 and if this still not matches then it will look into 3rd column.
I have no problem with this when it has only one TABLE_ARRAY column but i fail with multiple....
Sorry can't make it more clear than this.
Thank you for any help
Bookmarks