Hi,

I am in need of a macro program to find the value of adjacent cell
that is given as input

Consider

Cells
A3 No of Trucks B3 Factor
0 1.1
1 1.3
2 1.55
3 1.6
4 1.8
5 1.96
6 2.1
7 2.25
A12 8 2.4

If Cell A1="No of Trucks" is given a value as 4, macro need to search
the range of value and write the adjacent cell value 1.8 in cell
B1="Factor".
Macro should include the search for value 0 to 8.

On Jun 11, 10:23*am, maniarasan wrote:
Hi,

I am in need of a macro program to find the value of adjacent cell
that is given as input

Consider

* Cells
A3 *No of Trucks B3 Factor
* * * * * 0 * * * * * * * * * * 1.1
* * * * * 1 * * * * * * * * * * 1.3
* * * * * 2 * * * * * * * * * * 1.55
* * * * * 3 * * * * * * * * * * 1.6
* * * * * 4 * * * * * * * * * * 1.8
* * * * * 5 * * * * * * * * * * 1.96
* * * * * 6 * * * * * * * * * * 2.1
* * * * * 7 * * * * * * * * * * 2.25
A12 * *8 * * * * * * * * * * 2.4

If Cell A1="No of Trucks" is given a value as 4, macro need to search
the range of value and write the adjacent cell value 1.8 in cell
B1="Factor".
Macro should include the search for value 0 to 8.

Probably VLOOKUP function can do it much easily.

in cell B1 paste the formula
=VLOOKUP(A1,$A$3:$B$12,2,0)

You have to change $A$3:$B$12 to actual table address

On Jun 11, 10:51*am, Javed wrote:
On Jun 11, 10:23*am, maniarasan wrote:





Hi,

I am in need of a macro program to find the value of adjacent cell
that is given as input

Consider

* Cells
A3 *No of Trucks B3 Factor
* * * * * 0 * * * * * * * * * * 1.1
* * * * * 1 * * * * * * * * * * 1.3
* * * * * 2 * * * * * * * * * * 1.55
* * * * * 3 * * * * * * * * * * 1.6
* * * * * 4 * * * * * * * * * * 1.8
* * * * * 5 * * * * * * * * * * 1.96
* * * * * 6 * * * * * * * * * * 2.1
* * * * * 7 * * * * * * * * * * 2.25
A12 * *8 * * * * * * * * * * 2.4

If Cell A1="No of Trucks" is given a value as 4, macro need to search
the range of value and write the adjacent cell value 1.8 in cell
B1="Factor".
Macro should include the search for value 0 to 8.

Probably VLOOKUP function can do it much easily.

in cell B1 paste the formula
=VLOOKUP(A1,$A$3:$B$12,2,0)

You have to change $A$3:$B$12 to actual table address- Hide quoted text -

- Show quoted text -

Hi,

Can anyone help me with the macro program for above...