ExcelBanter - Ensure LOOkUP does not return #N/A

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Ensure LOOkUP does not return #N/A (https://www.excelbanter.com/excel-worksheet-functions/125086-ensure-lookup-does-not-return-n.html)

Nick Horn

Ensure LOOkUP does not return #N/A

I need to use LOOKUP or a variation (e.g. VLOOKUP) to convert numbers
(representing Grades) to numbers (representing points). Some of the pupils
do not have results and so LOOkUP returns #N/A.

How can I avoid it doing this? The resultant cell values will be used to
calculate means, standard deviation and COUNTIF calculations.

Many thanks for any help.

Teethless mama

Ensure LOOkUP does not return #N/A

=IF(ISNA(vlookup formula),"",vlookup forumula)

"Nick Horn" wrote:

I need to use LOOKUP or a variation (e.g. VLOOKUP) to convert numbers
(representing Grades) to numbers (representing points). Some of the pupils
do not have results and so LOOkUP returns #N/A.

How can I avoid it doing this? The resultant cell values will be used to
calculate means, standard deviation and COUNTIF calculations.

Many thanks for any help.

All times are GMT +1. The time now is 04:21 AM.