Vlookup with conditions
 

I'm trying to do a vlookup with a couple conditions, and I can't figure it
out. I'm sure the formula is relatively simple, I just can't figure out the
right language to use. Here is what my data looks like:

Sheet 1
Column A Column B Column C
Acct. #s Dollar amts. Description of purchase

Sheet 2:
(same)
Column A Column B Column C
Acct. # Dollar amts. Description of purchase
Trying to do vlookup on sheet 2 to find acct # and dollar amount, and pull
in description of purchase from sheet 1.

Why this isn't working: I have 2 problems. 1. I can't figure out how to
make it look for the acct and dollar amount together (because more than one
account might have a $10 purchase, for example) and 2. I'm dealing with data
from 2 different sources--one source includes cents, the other rounds to the
nearest dollar (is there a way to make the vlookup getting data from the
cents sheet round off, and recognize that $249.99 from sheet 1 is the same as
$250.00 on sheet 2?)

Thanks so much--any help is appreciated!

Vlookup with conditions
 

Try ... entered with Ctrl+Shift+Enter: you will gt {} brackets appear rounf
the formula if entered correctly.

in C2 on Sheet2 (assuming data starts row 2):

=INDEX(Sheet1!C1:C100,MATCH(1,(A2=Sheet1!A1:A100)* (B2=ROUND(Sheet1!B1:B100,0)),0))

retrieves description form Sheet1

I have assumed $249.49 will round (down) to $249

HTH

"Sam" wrote:

I'm trying to do a vlookup with a couple conditions, and I can't figure it
out. I'm sure the formula is relatively simple, I just can't figure out the
right language to use. Here is what my data looks like:

Sheet 1
Column A Column B Column C
Acct. #s Dollar amts. Description of purchase

Sheet 2:
(same)
Column A Column B Column C
Acct. # Dollar amts. Description of purchase
Trying to do vlookup on sheet 2 to find acct # and dollar amount, and pull
in description of purchase from sheet 1.

Why this isn't working: I have 2 problems. 1. I can't figure out how to
make it look for the acct and dollar amount together (because more than one
account might have a $10 purchase, for example) and 2. I'm dealing with data
from 2 different sources--one source includes cents, the other rounds to the
nearest dollar (is there a way to make the vlookup getting data from the
cents sheet round off, and recognize that $249.99 from sheet 1 is the same as
$250.00 on sheet 2?)

Thanks so much--any help is appreciated!

Vlookup with conditions
 

This worked great--thanks!

"Toppers" wrote:

Try ... entered with Ctrl+Shift+Enter: you will gt {} brackets appear rounf
the formula if entered correctly.

in C2 on Sheet2 (assuming data starts row 2):

=INDEX(Sheet1!C1:C100,MATCH(1,(A2=Sheet1!A1:A100)* (B2=ROUND(Sheet1!B1:B100,0)),0))

retrieves description form Sheet1

I have assumed $249.49 will round (down) to $249

HTH

"Sam" wrote:

I'm trying to do a vlookup with a couple conditions, and I can't figure it
out. I'm sure the formula is relatively simple, I just can't figure out the
right language to use. Here is what my data looks like:

Sheet 1
Column A Column B Column C
Acct. #s Dollar amts. Description of purchase

Sheet 2:
(same)
Column A Column B Column C
Acct. # Dollar amts. Description of purchase
Trying to do vlookup on sheet 2 to find acct # and dollar amount, and pull
in description of purchase from sheet 1.

Why this isn't working: I have 2 problems. 1. I can't figure out how to
make it look for the acct and dollar amount together (because more than one
account might have a $10 purchase, for example) and 2. I'm dealing with data
from 2 different sources--one source includes cents, the other rounds to the
nearest dollar (is there a way to make the vlookup getting data from the
cents sheet round off, and recognize that $249.99 from sheet 1 is the same as
$250.00 on sheet 2?)

Thanks so much--any help is appreciated!