Displaying value of specific cell within a range, with IF function...?

hello

i'm not particularly Excel literate, so any help much appreciated

i've been given a spreadsheet that looks something like this:
A B C D E
Prod Prod
Site:1 Code Old Price New Price Code New Price
3225 4.83 4.93 2643 £16.22
3280 5.04 3225 £4.93
5500 9.9 5500 £9.90
6457 4.9 30316 £4.50
30231 5.2 31043 £4.50
30316 4.5 6457 £4.99
31043 4.5 30231 £5.40
31220 4.66 31220 £4.66

the last two columns i have pasted in from a word doc - these detail
the product code and their new price adjacent - i have created cell
ranges based on these - but i'm not sure what to do from there...

the table is some 5000 rows, although there are only around 100 prod
codes in total - they are repeated and in random order as per the
different sites

so what i need, if possible, is a function in the C.'New Price'
column, that will refer to the first A.'Prod Code' column value, look
for it in the D.'Prod Code' column, and, if found, display the price
value of the adjacent E.'New Price' column...

so i could then drag it down through Column C.

i've been messing around with the functions to no avail - i'm wasn't
even sure how to entitle this plea for help...!

thanks

Steve

It looks like =vlookup() would work for you.

See Debra Dalgleish's site for nice instructions:
http://www.contextures.com/xlFunctions02.html



Steve wrote:
>
> hello
>
> i'm not particularly Excel literate, so any help much appreciated
>
> i've been given a spreadsheet that looks something like this:
> A B C D E
> Prod Prod
> Site:1 Code Old Price New Price Code New Price
> 3225 4.83 4.93 2643 £16.22
> 3280 5.04 3225 £4.93
> 5500 9.9 5500 £9.90
> 6457 4.9 30316 £4.50
> 30231 5.2 31043 £4.50
> 30316 4.5 6457 £4.99
> 31043 4.5 30231 £5.40
> 31220 4.66 31220 £4.66
>
> the last two columns i have pasted in from a word doc - these detail
> the product code and their new price adjacent - i have created cell
> ranges based on these - but i'm not sure what to do from there...
>
> the table is some 5000 rows, although there are only around 100 prod
> codes in total - they are repeated and in random order as per the
> different sites
>
> so what i need, if possible, is a function in the C.'New Price'
> column, that will refer to the first A.'Prod Code' column value, look
> for it in the D.'Prod Code' column, and, if found, display the price
> value of the adjacent E.'New Price' column...
>
> so i could then drag it down through Column C.
>
> i've been messing around with the functions to no avail - i'm wasn't
> even sure how to entitle this plea for help...!
>
> thanks
>
> Steve

--

Dave Peterson