Dear all,
I have a problem fixing the formula using VLOOKUP and IF function.. can somebody try to help me? thank you in advance... attached is a sample table...
Dear all,
I have a problem fixing the formula using VLOOKUP and IF function.. can somebody try to help me? thank you in advance... attached is a sample table...
Your problem was you had FALSE instead of TRUE on the VLOOKUPs
and you can shorten that code to this
in L3
=IF(I3="B",VLOOKUP(K3,IF(J3="UNS",$E$13:$F$17,IF(J3="SEC-1",$E$18:$F$23,$E$24:$F$29)),2,TRUE),"Not Found")
and copy down
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
I advice you NOT to work with merged cells, you get in trouble with it sooner or later.
With a couple of helpcolumns and indirect I made this solution.
I bet there is a neater solution, but it works.
See the attached file.
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.
Formula in L3 then dragged down.
Please Login or Register to view this content.
L3Try this and copy towards downPlease Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
To: Special-K, oeldere, kvsrinivasamurthy & nflsales
Thanks to all of you.... I've tried all your formula and it all worked. I really appreciate your time and effort... thanks a lot.
Marj
You're welcome. We appreciate the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
Thank you oeldere ....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks