# using a max formula on a column with no data to give a Blank result

1. ## using a max formula on a column with no data to give a Blank result

I知 a trainer and I知 trying to streamline my admin. I have a spreadsheet with a various sheets:
Sheet 1 has all names and courses that we do

Sheet 2 has all the workers profiles
Sheet 3 + has each individual course and we input date and test result
In Row 40 of these spreadsheet I have the following Formula for date: =MAX(B9:B38) and for mark: =VLOOKUP(MAX(B9:B38),B9:C38,2,0)

The current result for date: 00 Jan 00 and mark: #N/A.
I知 using the info in this row to go into sheet 1. As there is no data loaded I would like the info to reflect a blank in the column until there is data.

How can I do that?

2. ## Re: using a max formula on a column with no data to give a Blank result

Try

Formula:
`Please Login or Register  to view this content.`

Formula:
`Please Login or Register  to view this content.`

3. ## Re: using a max formula on a column with no data to give a Blank result

Originally Posted by Fotis1991
Try

Formula:
`Please Login or Register  to view this content.`

Formula:
`Please Login or Register  to view this content.`
Thanks a million Works perfectly!

4. ## Re: using a max formula on a column with no data to give a Blank result

You are welcome and thanks for the feed back.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

5. ## Re: using a max formula on a column with no data to give a Blank result

Try this "Iferror(VLOOKUP(MAX(B9:B38),B9:C38,2,0)),""). I think this will fix you result. Good luck!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1