VBA Color + VLOOKUP

[TOKYOJ1]

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]

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]

Hi,

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

Thanks!
TJ

 

[James006]

You are welcome