excel function

[matthay]

Hi,

I'm struggling to enter the correct function, can somebody please help.

I want to search on a specified value contained in the 1st spreadsheet for the same value in a second spreadsheet. Once found I want the relevant row in the 1st spreadsheet to autofill with data from the 2nd spreadsheet.

Spreadsheet 1:

Code ] Address 1

123 ] to be filled from 2nd spreadsheet

Spreadsheet 2:

Code ] Address 1

123 ] 20 the road, somewhere

I know this is possible but can't seem to find the function - it will be something similar to Vlookup but I can't figure it out.

I hope I have explained it well enough and would really appreciate your suggestions

[Aquariel]

It is VLOOKUP you will need to use. Firstly, your 'source' address list should be sorted in numerical order of your 'code' column.

Then, in your lookup cell, use the following formula:

=VLOOKUP(A1,sheet2!A1:B20,2)

where:

A1 is the value you want to search for

sheet2!A1:B20 is the range of addresses with 'code' in the first column and the address in the second column

2 is the column number to retrieve info from (in this case column 2).

Hope that helps!

[praneshx]

i know something which i can help you through what i learned from about excel function from the following referral link!!
http://www.hscripts.com/tutorials/excel2007/