Hi,
im using the formula =VLOOKUP(D4,'Raw Data Detail'!A:AE,3,FALSE)
can someone please help me with how to add if NA the cell needs to be blank.
Thanks in advance
Hi,
im using the formula =VLOOKUP(D4,'Raw Data Detail'!A:AE,3,FALSE)
can someone please help me with how to add if NA the cell needs to be blank.
Thanks in advance
Last edited by rocky001c; 09-30-2014 at 11:22 AM.
Not sure what functions are available for Excel 2008. Try
=IFERROR(VLOOKUP(D4,'Raw Data Detail'!A:AE,3,FALSE), "")
Does that work?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Yes!!!
thank you!!
one more question, can you do if error hide row?
thanks
No, not with a formula. You could have conditional formatting to color the row or you could filter on blanks for whichever column that formula is in. Or you could use programming
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks