formula problem. Find if a formula has entered data into a cell

Hi

I have a formula(Vlookup) in a cell and it is looking for data. If it
finds it, it places it into the cell. I want to place a formula
inanother cell that then looks at this cell and determins if it has
placed the data into that cell by inserting a 1 into another cell if
not a 0


---
Message posted from http://www.ExcelForum.com/

If you have a VLOOKUP formula in a cell, it will return either a value or an
error. It will not be 0 unless 0 is the result of the lookup. What exactly
are you trying to accomplish?

--

Vasant

"con_tg " wrote in message
...
Hi

I have a formula(Vlookup) in a cell and it is looking for data. If it
finds it, it places it into the cell. I want to place a formula
inanother cell that then looks at this cell and determins if it has
placed the data into that cell by inserting a 1 into another cell if
not a 0


---
Message posted from http://www.ExcelForum.com/

If I understand what you're asking, you could first make sure that your
lookup formula is set-up to return a null if it doesn't find any data to
return.

Then, have the formula in your second cell just look for the null, and then
return a 0, otherwise, return a 1.

For example, the lookup formula could be similar to this:

=IF(ISNA(MATCH(C1,A1:A10,0)),"",VLOOKUP(C1,A1:B10, 2,0))

Now, if the lookup formula was in D1, the second formula could be similar to
this:

=--(D1"")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"con_tg " wrote in message
...
Hi

I have a formula(Vlookup) in a cell and it is looking for data. If it
finds it, it places it into the cell. I want to place a formula
inanother cell that then looks at this cell and determins if it has
placed the data into that cell by inserting a 1 into another cell if
not a 0


---
Message posted from http://www.ExcelForum.com/