range table is zero (excel97)

Topic

New Reply

hello there
Im trying out this solution by using macro (pls see attachment)
I have done partly thru macro VB but when i run it the result of CCC shows #N/A because it does not have the record for it. What i want is how to show if there is no such record it shld be blank instead of #N/A and if theres a record it will show the value. Pls help
Thank you
nuglorious

Reply | Quote

Replies

No need to use VBA. Enter this formula in E9:

=IF(ISNA(VLOOKUP(E8,$E$15:$F$18,2,0)),””,VLOOKUP(E8,$E$15:$F$18,2,0))

and fill right to H9. The ISNA function tests if the result of VLOOKUP is #N/A. If so, return a blank, otherwise the result ot VLOOKUP. The reference to E15:F18 has been made absolute by pressing F4 (witness the $ characters) to make copying the formula to other cells possible.

Reply | Quote

alright..it works
you are really an expert…. I wish i could be like you…
Thank you

Reply | Quote

alright..it works
you are really an expert…. I wish i could be like you…
Thank you

Reply | Quote

No need to use VBA. Enter this formula in E9:

=IF(ISNA(VLOOKUP(E8,$E$15:$F$18,2,0)),””,VLOOKUP(E8,$E$15:$F$18,2,0))

and fill right to H9. The ISNA function tests if the result of VLOOKUP is #N/A. If so, return a blank, otherwise the result ot VLOOKUP. The reference to E15:F18 has been made absolute by pressing F4 (witness the $ characters) to make copying the formula to other cells possible.

Reply | Quote