Apr 20 2021 04:39 PM
In the spreadsheet attached, the formula appears in each cell but it doesn't work in some of them. I thought the copy/paste would would accross all cells that had data in them.
Apr 21 2021 12:14 AM
@marty007 Better to upload the file in stead of a PDF. Then we can see what's going on.
Apr 21 2021 08:04 AM
I've uploaded the actual file. Thanks.
Apr 21 2021 08:28 AM
@marty007 Cell D5 has a space, therefore VLOOKUP returns a space, thus a seemingly empty cell. D6 is empty, therefore VLOOKUP returns 0. F7 looks up Eddie and VLOOKUP finds the first Eddie in the list (on row 6) and thus also returns 0.
You could combine the First and Last name into one column to overcome the latter problem.
Apr 21 2021 08:40 AM
Apr 21 2021 08:43 AM
@marty007 Put the cursor in the formula bar and press <backspace>. If it moves towards the left there was a space. Otherwise enter =ISBLANK(D5) in a free cell. If it comes out TRUE, it is empty. If it says FALSE it is not.
Apr 21 2021 09:16 AM
SolutionApr 21 2021 09:16 AM
Solution