P
peyman
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
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