hey every one
i have this formula :
=IF(J12="",VLOOKUP(K12,$C$11:$G$20,5,FALSE),IF(K12="",VLOOKUP(J12,$C$11:$G$20,4,FALSE)))
when cell j12 not empty the formula works fine and the same for cell k12.
but when these 2 cells are empty im getting #N/A which i want to remove it .
can some one help please
thanks
try
Formula:
Please Login or Register to view this content.
Edit:
For Excel2003, try,.
Formula:Please Login or Register to view this content.
Last edited by Fotis1991; 02-18-2014 at 03:36 AM. Reason: Edit
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Try this.........
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Thankssssssssssss alotttttt
Glad to help you. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks