View Single Post
  #2   Report Post  
Old February 15th 05, 08:51 PM
RagDyer
 
Posts: n/a
Default

You can use Vlookup.

Account numbers on Sheet1, A2 to A6000.

Account numbers on Sheet2, A2 to A6000
Amounts on Sheet2, B2 to B6000.

Enter this in B2 of Sheet1:

=VLOOKUP(A2,Sheet2!$A$2:$B$6000,2,0)

You can drag down to copy, or the easy way is to double click on the "fill
handle" in the lower right corner of B2, which will copy the formula in B2
down Column B, as far as there is data in Column A.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"The Good Deeds Team" wrote in
message ...
I have two spreadsheets.

the first has a list of account numbers, for example

10
20
30

The second has a list of acount numbers and an amount, for example

10 100
20 150
30 175

How can I in the fisrt spreadsheet, use a formula to look in the second
spreadsheet for the corresponding account number, example 20, and pull the
correct value, example 150 withoutout coding each row in the first
spreadsheet to look exactly at the specific row in the second spreadsheet

For example, I can do this and it works

=(second spreadsheet!$F$11)

however I just want it to know where in the second spreadsheet column F the
value 20 exists and pull 175 from colum G

I don't want to have to tell the firts spreadsheet it is on row 11, I want
it to look through coulmn F and find the value 20, which matches the value
in
the first spreadsheet, and then give me the amount from that row in the
second spreadsheet, say column g

this application is really 6000 accounts in the first spreadsheet, that need
to match 6000 accounts in the second spreadsheet, and I don't want to code
it
row by row, simplely match the accopunt numbers from the two spreadsheets
and
give me a value on the corresponding row.