Returnig a value

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: peyman <peyman@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 25 May 2009 14:20:01 -0700

Hi,
I have a sample data reference file like below:

column A column B column C

055555 AA 1000
088888 BB 5600
077777 CC 6000
033333 BB 2000

now if I have the first 2 columns in another file , how can I write a
formula to return me the corresponding column C value in reference file if
the values in the first 2 columns in second file and the ref. file are
identical. for example:

in second file:
if:
column A column B
033333 BB
then in the column C the formula returns 2000.
I hope I'm clear on that.
Thanx,
Peiman

.

Follow-Ups:
- RE: Returnig a value
  - From: Gary''s Student

Prev by Date: Re: How to sumproduct only filtered data
Next by Date: Transparency slider and Fill trouble in Autoshape
Previous by thread: How to sumproduct only filtered data
Next by thread: RE: Returnig a value
Index(es):
- Date
- Thread

Relevant Pages

Re: Need help with substitution --DONE
... Nisse Tuta wrote: ... I need to change the second number in the second file. ... The reference file have the 016 in more then 1 place so the second match would be the timecode 17:10:40:14 is inbetween the timecodes in the refrence file. ...
(perl.beginners)
Re: Need help with substitution
... showing. ... I need to change the second number in the second file. ... The reference file have the 016 in more then 1 place so the second ... match would be the timecode 17:10:40:14 is inbetween the timecodes in ...
(perl.beginners)
Need help with substitution
... Sorry for the long message but I find it hard to explain without showing. ... I need to change the second number in the second file. ... The reference file have the 016 in more then 1 place so the second match would be the timecode 17:10:40:14 is inbetween the timecodes in the refrence file. ...
(perl.beginners)
Re: ad-aware, do you need to be online
... > Do you need to be on line to update the ref. ... Navigate to the folder where the Reference File is stored. ... Start Ad-aware and load the Reference File panel and check the "details" view ... of the installed Reference File to ensure that you have an installed useable file. ...
(microsoft.public.security)