VBA Color + VLOOKUP

TOKYOJ1

New Member
Joined
Aug 14, 2017
Messages
30
Hi

I am not familiar with VBA and hope that somebody can assist.

SheetA:

A1 B1 C1
101 98

If I manually highlight cell A1 at C1 = vlookup(A1,SheetB!,2...
If I manually highlight cell B1,at C1 = vlookup(B1,SheetC!,2...

(Highlight A1, refer sheetB, highlight B1 refer SheetC)


Can anyone assist?

Thanks
TJ
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hello,

Have you tried to turn on your macro recorder ... and input your formula ...

You will get an initial VBA translation of your formula ...

Hope this will help
 

TOKYOJ1

New Member
Joined
Aug 14, 2017
Messages
30
Hi,

I think you gave a great suggestion, at least helps me to understand portions of it.

Thanks!
TJ
 

Forum statistics

Threads
1,082,607
Messages
5,366,591
Members
400,904
Latest member
srija

Some videos you may like

This Week's Hot Topics

Top