Ste1978
Here's a little help on that:

SHEET1
A B

1 1.4 3RV1011-1BA10.
2 1.2 3RV1011-1BA10.
3 1.3 3RV1011-1BA12.
5 1.6 3RV1011-1BA13.
6 2 3RV1011-1BA14.
Let's assume this is your setup
SHEET2 ( optional, can be on same sheet too)
A B
1 1.4 =VLOOKUP(A1,Sheet1!A1:C5,2,FALSE)

will return:

A B
1 1.4 3RV1011-1BA10.

http://www.contextures.com/excelfiles.html
has a good explanation

=VLOOKUP(ItemToFind,RangeToLookIn,ColumnToPickFrom ,SortedOrUnsorted)
The ItemToFind is a single item specified by the user.
The RangeToLookIn is the range of data with the row headings at the left
hand side.
The ColumnToPickFrom is how far across the table the function should look to
pick from.
The Sorted/Unsorted is whether the column headings are sorted. TRUE for yes,
FALSE for no.

HTH





"Norman Jones" wrote:

Hi Ste1978,

I just want a step by step guide on how to begin? I read the help for
VLOOKUP but I still do not understand.

See Debra Dalgleish's VLookup tutorial at:

http://www.contextures.com/xlFunctions02.html


---
Regards,
Norman



"Ste1978" wrote in
message ...

Hi thanks for the reply,

I still don't know how to start, I have hardly any excel training at
all!

I just want a step by step guide on how to begin? I read the help for
VLOOKUP but I still do not understand.


--
Ste1978
------------------------------------------------------------------------
Ste1978's Profile:
http://www.excelforum.com/member.php...o&userid=32398
View this thread: http://www.excelforum.com/showthread...hreadid=521647