Possibly combining counta and vlookup

**skatmandu2002** · 01-20-2009, 03:58 PM

Hiya,

There is a table with headings A1:F1, and numerous rows underneath (A2:F20). Under the headings, some numbers or text are typed under the headings, but not all fields are completed (many are left blank).

At a separate part of the spreadsheet, the user selects one of the headings (using a data validation list) in Cell B30. Then cells B32:B50 (corresonding to rows 2:20) will display "YES" if the corresponding field in the table HAS DATA ENTERED, and "NO" if it doesn't.

Hope this makes sense and any help is much appreciated!

Thanks

**mewingkitty** · 01-20-2009, 04:02 PM

There is a table with headings A2:A10, and numerous rows underneath (B2:B20)

That's not underneath, that's beside.

You sure you got that typed out correctly?

**skatmandu2002** · 01-20-2009, 04:31 PM

Sorry, I did make a mistake. You can tell I have been quiet on the Excel front fro a couple of months. Here is the correct post (any admins can replace my first post with it):

There is a table with headings A1:F1, and numerous rows underneath (A2:F20). Under the headings, some numbers or text are typed under the headings, but not all fields are completed (many are left blank).

At a separate part of the spreadsheet, the user selects one of the headings (using a data validation list) in Cell B30. Then cells B32:B50 (corresonding to rows 2:20) will display "YES" if the corresponding field in the table HAS DATA ENTERED, and "NO" if it doesn't.

Hope this makes sense and any help is much appreciated!

Thanks