Hi (first time)
I am using a formula =IF(ISBLANK(VLOOKUP($D20,Glk!$A$4:$AV$202,Glk!G$3+6,FALSE)) = FALSE,VLOOKUP($D20,Glk!$A$4:$AV$202,Glk!G$3+6,$D20),"")
This pulls value's from sheet1 (Glk) but I am wanting to add another sheet2 (Def) to the formula.
Is this possible!!
Thank you
Its possible, the final formula depends on what you want the second vlookup to do.
It also helps if you describe what it is that you ultimatelly are trying to achieve with this formula.
It would avoid the "trial and error" approach.
Last edited by Portuga; 04-10-2008 at 12:35 PM.
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks