Hello!
I would like to know if it's possible to use VLOOKUP formula by Field Calculator.
I need to fill some informations according to data in attribule table. To exemplify, i'm using this table below.
| column A | column B | column C | column D |
| COTM | OTTOM | COTJ | OTTOJ |
| row 3 | AD2 | 88ab | AD2 | |
| row 4 | DF3 | 87ab | AD2 | |
| row 5 | TR5 | 86ab | TR5 | |
| row 6 | GH4 | 85ab | FS2 | |
| row 7 | FS2 | 84ab | TR5 | |
If were to do the calculation by Excel, the operation would be simple, like: D3 = VLOOKUP (C3;A:B;2;FALSE)
How would be VBAcript for VLOOKUP function by Field Calculator?If someone know how to help me, I appreciate.