andyandy12345
New Member
- Joined
- Feb 26, 2011
- Messages
- 11
Hi -need help to with VBA code to compare or lookup a value based on two inputs from separate columns.
Essentially I have two columns which need to be looked at to determine the desired result.
The columns will only contain the following inputs
column A column B Result
Text1 0 0
Text1 4 1
Text1 8 2
Text1 16 3
Text1 24 4
Text2 0 0
Text2 4 2
Text2 8 3
Text2 16 4
Text2 24 5
TIA
So if column A = Text1 AND column B = 4 THEN output the vlue in the Result column eg 1
Essentially I have two columns which need to be looked at to determine the desired result.
The columns will only contain the following inputs
column A column B Result
Text1 0 0
Text1 4 1
Text1 8 2
Text1 16 3
Text1 24 4
Text2 0 0
Text2 4 2
Text2 8 3
Text2 16 4
Text2 24 5
TIA
So if column A = Text1 AND column B = 4 THEN output the vlue in the Result column eg 1