Help with "if-then"/look up commands or what ever you think is best.

[rdill04]

I'm trying to populate a set of accounts from another part of the
sheet. There are a few thousands lines so I want to automate this.

The way this sheet is set up we have 6 columns.

1. Column A - full list of accounts from begining to end in numerical
order. They are not succsessive however. The list doesn't go
1,2,3,4,5,6,7,8.... Its goes 1,3,4,6,7,9 but there are no 2,5,8
accounts.

2. Column B is where I want the value to be put.

3. Column C irrelevent

4. Column D irrelevent

5. Culumn E is the list of accounts that I want to match with column
A.

6. Column F is the coresponding value to accounts in Column E.

Here is an example of the relationship between Columns A and E.

A B E F
1 1 5.00
2 3 9.00
3 4 11.00
5 8 4.00
7 11 2.00
8
10
11
12
13
15
17
23

I want the values from F to go into the correct row in B. Please help
me, and thank you in advance for all your help.

Respectfully.

 

[Dave Peterson]

Take a look at Debra Dalgleish's site for instructions on how to do =vlookup().
http://www.contextures.com/xlFunctions02.html

But one thing you may want to do is move columns E:F to a new worksheet (in
columns A:B).

It'll make life lots easier if you ever have to add/delete rows.

 

[Brijesh (b_sh]

Select the range of columns E & F and give it a range name. If you dont know
how, go to Insert->Name->define and select the range top to bottom of
concerned cells under E & F. Say you give the name as 'dave'.

Then under column B (say cell B2) next to the column A where you want the
corresponding value for cell A2, write @vlookup(A2,dave,2,false)

Copy the formula all the way down. Will help u for sure.

Brijesh