Forum Discussion
marty007
Apr 20, 2021Brass Contributor
Excel fomula not showing results for some cells
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, 2021Wow! that was extremely helpful. I will pay more attention when entering data in the future.
Many thanks.
marty007
Apr 21, 2021Brass Contributor
I've uploaded the actual file. Thanks.
Riny_van_Eekelen
Apr 21, 2021Platinum Contributor
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.
- marty007Apr 21, 2021Brass ContributorI now understand about the 2 Eddie names. I will concanate the names. Thanks. How can I tell that D5 has a space and D6 is emply? Both cells appear blank and the formula bar is also blank for each cell?
- Riny_van_EekelenApr 21, 2021Platinum Contributor
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.
- marty007Apr 21, 2021Brass ContributorWow! that was extremely helpful. I will pay more attention when entering data in the future.
Many thanks.