View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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!