# Thread: Lookup formula (2003 SP3)

2. ## Lookup formula (2003 SP3)

I am new at lookup formulas and need help figuring out how to match the two sheets on the zip file (150k) located at the link below.

What I would like is if the account numbers match on Sheet 1 and 2, then the consumption data from sheet 2 gets transferred to sheet 1. Hopefully makes sense. Thank you.

3. ## Re: Lookup formula (2003 SP3)

I just checked and it worked fine for me. I added the 'hit download button' information above. Thank you.

4. ## Re: Lookup formula (2003 SP3)

In D2, you can use =VLOOKUP(A2,Consumption!A:B,2,FALSE)

HTH.

5. ## Re: Lookup formula (2003 SP3)

Welcome to Woody's Lounge!

You can use VLOOKUP for this. The basic formula is

=VLOOKUP(A2,Consumption!\$A\$2:\$B\$6560,2,0)

in D2. However, this will return #N/A if there is no match. To suppress this, you can use

=IF(ISNA(VLOOKUP(A2,Consumption!\$A\$2:\$B\$6560,2,0)) ,"",VLOOKUP(A2,Consumption!\$A\$2:\$B\$6560,2,0))

You can fill down from D2 to the end of the table.

Note: it isn't necessary to supply a huge workbook with thousands of rows. A reduced sample file with a very limited number of rows is easier to attach and to handle. So in the future please take a few minutes to create a small workbook that can be attached directly to a post. Thank you in advance.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•