Hi all,
I am doing a simple LOOKUP formula: =LOOKUP($B2, $L$5:$L$10, $M$5:$M$10)
But I am using a spreadsheet which will gradually get added to. If I apply this formula to cells where there isn't any value in B5 for example it comes back with N/A. Is it possible to amend the code for it to ignore blank cells until the look up value has been typed in?
Many thanks
Try
=IFERROR(LOOKUP($B2, $L$5:$L$10, $M$5:$M$10), "")
Click * below if this answer helped
Fantastic, thanks Chris. Now lastly, someone has entered the following formula into the cell next to where the result from the Lookup goes to add another total onto the total returned:
=G6*0.2+G6
Because the result is now blank unless there is a lookup value entered, that formula now returns: #VALUE! Is it possible to do something similar with this one?
Thanks again
Try
=IFERROR(LOOKUP($B2, $L$5:$L$10, $M$5:$M$10), 0)
OR
+ISERROR(G6*0.2+G6,"")
OR
=ISERROR(G6 *1.2,"")
There is always more than one way.
Here's another one...
=IF($B2="","",LOOKUP($B2,$L$5:$M$10))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
One way...
=IF(COUNT(G6),G6*1.2,"")
Or you could do without the formula in G6 and combine both formulas with something like
=IFERROR(LOOKUP($B2, $L$5:$L$10, $M$5:$M$10)*1.2, 0)
Thank you everyone. Tony that was perfect for what I need.
Thanks again
You're welcome. 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