I've done some research on this and understand the solution involves adding "" to the formula. But it doesn't seem to work for me - I expect I'm missing something simple.
If anyone's got a minute to take a look at the formula in sheet 2, cell C16, it would be most appreciated.
Thanks.
Martin
=if(c14="ila a",vlookup(c15,j11:k61,2,),if(c14="ila b",vlookup(c15,m11:n75,2,),if(c14="ila c",vlookup(c15,p11:q64,2,),"")))
Hi there. now it will return something ONLY if C14 and C15 have a value entered.
Formula:
Please Login or Register to view this content.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Formula:Please Login or Register to view this content.
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.
Use
=IF(C14="ILA A",VLOOKUP(C15,J11:K61,2,),IF(C14="ILA B",VLOOKUP(C15,M11:N75,2,),IF(C14="ILA C",VLOOKUP(C15,P11:Q64,2,),"")))
Life's a spreadsheet, Excel!
Say thanks, Click *
Guess I beat you guys to it =)
There is no data in C14 and no data in C15 so the Vlookformula won't work (as you expected).
You also used merged cells in your file.
Don't use them (my advice), you get in trouble with it sooner or later.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
That did it. And in record time. Great - thanks a lot.
Hi Stanners,
Try this formula in C16:
=IF(C14="","",(IF(C14="ILA A",VLOOKUP(C15,J11:K61,2,FALSE),IF(C14="ILA B",VLOOKUP(C15,M11:N75,2,FALSE),IF(C14="ILA C",VLOOKUP(C15,P11:Q64,2,FALSE))))))
Wow!! I was very late to this party. I guess I'll go do something else while other people answer questions.
Last edited by MarvinP; 06-15-2015 at 12:38 PM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
A feast of answers!!! At least you got sorted out...
Thanks to everyone who chipped in.
Originally Posted by JieJenn
Youngster!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks