Cant place a value of 0.00 if match is found in table

**kwik98** · 10-22-2010, 05:36 PM

Not sure if this is a vba issue or formula issue. I have a workbook with several sheets. In sheet "Schedule", I have a table built and added to by data validation boxes. The whole table is made from cells that ALL have data validation. Some are blank...some are not. I add to them often. The data validation is done from Column A in Sheet2.
On Sheet2, I have a table of four columns and and 600+ rows. In column A, I have data all the way down, no blanks. In column C, all cells are blank.
As I put data into cells on the "Schedule" worksheet ( using data validation), I want to look for a match in Sheet2,ClolumnA . If a match is found, I want 0.00 to be placed in Column C, whichever row that has the match in it.
It needs look for a match to any data that is put into the table in sheet"Schedule" to data in ColumnA,Sheet2.. The data will never be entered twice so its a unique match.

**Cutter** · 10-22-2010, 09:28 PM

I haven't looked at your file but it sounds like you can use a formula in Col C of Sheet 2.

Please Login or Register  to view this content.

if table is not named be sure to use absolute reference for its range and copy down to bottom of Col C

Format Col C as number with 2 decimals

**kwik98** · 10-23-2010, 12:16 PM

Worked great! thank you for your time and help.

**Cutter** · 10-23-2010, 12:25 PM

You're welcome. Glad you got it working.

Don't forget to mark your post as SOLVED.

**kwik98** · 10-23-2010, 02:52 PM

How is that done Cutter? I'm not sure.

**Cutter** · 10-23-2010, 04:35 PM

From the FAQ area:

"To mark your thread solved do the following: - Go to the first post - Click edit - Click Advance - Just below the word "Title:" you will see a dropdown with the word No prefix. - Change to Solve - Click Save"