I need to create a match-up formula that returns the value from another
column. I have 2 cloumns (trailer numbers and their corresponding
commodity), and I have another column which has the same trailer numbers and
I want to create a match-up program that will search in column D for a match
in column A, then return its value in column B; here is an example:

Column A Column B Column D Column E
Trailer Commodity Trailer (match trailer # in column D w/
column A,
5271 Clamp 5271 return value in column B)
5502 Clamp 7912
7912 Clamp 8659
8592 Clamp 8682
8659 Clamp 8900
8682 Cart 9233
8900 Clamp 10837
9233 Clamp
10837 Clamp
10908 Clamp

try a vlookup in column E

assuming e3 is the first row of actual data

=vlookup(D3,A3:B12,2,false)
--
If this helps, please remember to click yes.


"Melvin_Flint_2247" wrote:

> I need to create a match-up formula that returns the value from another
> column. I have 2 cloumns (trailer numbers and their corresponding
> commodity), and I have another column which has the same trailer numbers and
> I want to create a match-up program that will search in column D for a match
> in column A, then return its value in column B; here is an example:
>
> Column A Column B Column D Column E
> Trailer Commodity Trailer (match trailer # in column D w/
> column A,
> 5271 Clamp 5271 return value in column B)
> 5502 Clamp 7912
> 7912 Clamp 8659
> 8592 Clamp 8682
> 8659 Clamp 8900
> 8682 Cart 9233
> 8900 Clamp 10837
> 9233 Clamp
> 10837 Clamp
> 10908 Clamp
>
>