maarten_zee
New Member
- Joined
- Jan 27, 2004
- Messages
- 8
Given the following sheets...
VJP
InputFromKing
I'd like to look up "Naam" associated with the value in B3 on VJP from InputFromKing by means of VBA code. If nothing found, I'd like the following message to appear instead:<Vul hier een omschrijving of een naam>.
Thanks in advance.
VJP
output+25-01-04.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Voorafgaandejournaalposten | |||||
2 | Rubriek | Rekening | Naam | |||
3 | Rubriek_1 | 1110 | ||||
4 | Rubriek_4 | 4610 | ||||
5 | Rubriek_1 | 1420 | ||||
6 | Rubriek_3 | 3000 | ||||
7 | Rubriek_6 | 6004 | ||||
8 | Rubriek_6 | 6004 | ||||
VJP |
InputFromKing
output+25-01-04.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Rekening | Naam | ||||
2 | 0010 | Aandelenkapitaal | ||||
3 | 0230 | Inventariseninrichting | ||||
4 | 0240 | Computersenrandapperatuur | ||||
5 | 0250 | Intrenrtransport | ||||
6 | 0810 | Leninging | ||||
7 | 0820 | Leaseverplichting | ||||
InputFromKing |
I'd like to look up "Naam" associated with the value in B3 on VJP from InputFromKing by means of VBA code. If nothing found, I'd like the following message to appear instead:<Vul hier een omschrijving of een naam>.
Thanks in advance.