I am using Excel 2003

I have two tabs in my file.

Tab 1 has account numbers in column A; in column C I want to put the cost to
date

The cost to date is in Tab 2, the same account number is in column A and the
cost is in column O. The account number is not in the same row in Col A on
both Tabs. I am looking for a function that will look at Tab1/ColA and then
try and find the same account number in Tab2/ColA, when it does then put the
value on Tab2/ColO in Tab1/ColC. The data in Tab2 is from an ODBC and can be
upto 30 rows of data.

I hope the above is clear but if not I am sure I will be asked to clarify.

Thanks in advance.

--
CWH

=IF(NOT(ISNA(VLOOKUP(A1,Sheet2!A1:O50,15,False))), VLOOKUP(A1,Sheet2!A1:O50,1
5,False),"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CWH" wrote in message
...
I am using Excel 2003

I have two tabs in my file.

Tab 1 has account numbers in column A; in column C I want to put the cost
to
date

The cost to date is in Tab 2, the same account number is in column A and
the
cost is in column O. The account number is not in the same row in Col A
on
both Tabs. I am looking for a function that will look at Tab1/ColA and
then
try and find the same account number in Tab2/ColA, when it does then put
the
value on Tab2/ColO in Tab1/ColC. The data in Tab2 is from an ODBC and can
be
upto 30 rows of data.

I hope the above is clear but if not I am sure I will be asked to clarify.

Thanks in advance.

--
CWH

That is great but instead of returning a blank cell could I amend the formula
to return 0?
--
CWH


"Bob Phillips" wrote:

=IF(NOT(ISNA(VLOOKUP(A1,Sheet2!A1:O50,15,False))), VLOOKUP(A1,Sheet2!A1:O50,1
5,False),"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CWH" wrote in message
...
I am using Excel 2003

I have two tabs in my file.

Tab 1 has account numbers in column A; in column C I want to put the cost
to
date

The cost to date is in Tab 2, the same account number is in column A and
the
cost is in column O. The account number is not in the same row in Col A
on
both Tabs. I am looking for a function that will look at Tab1/ColA and
then
try and find the same account number in Tab2/ColA, when it does then put
the
value on Tab2/ColO in Tab1/ColC. The data in Tab2 is from an ODBC and can
be
upto 30 rows of data.

I hope the above is clear but if not I am sure I will be asked to clarify.

Thanks in advance.

--
CWH

replace the "" with 0