Excelnoobbb
New Member
- Joined
- Apr 28, 2017
- Messages
- 7
Hi,
i have this formula =IF($N13="","",VLOOKUP($N13,$A$8:$J$469,2)) that is returning a #N/A because A13 is a Text.
N13 =
<tbody>
</tbody>
If i make A13 into a number, it's still a #N/A because then A13 loses the 0 at the front...therefore is not found.
is there a fix?
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody></body>
i have this formula =IF($N13="","",VLOOKUP($N13,$A$8:$J$469,2)) that is returning a #N/A because A13 is a Text.
N13 =
024182141 |
<tbody>
</tbody>
If i make A13 into a number, it's still a #N/A because then A13 loses the 0 at the front...therefore is not found.
is there a fix?
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
024182141 |
<tbody>
</tbody>