Hi I'm really struggling with combining several functions in a formula.
I've written out the three functions as individual formulae and they seem to work but I want it to do it as one operation. The three are listed below:
1) =IF(VLOOKUP(B2,Titles,1,TRUE),1,0)
2) =IF(ISBLANK(B2),0,1)
3) =IF(ISNA(O2),0,1)
In formula 3) O2 refers to the results of formula 2)
Any ideas?
Hi and welcome to the forum.
Can you provide a workbook with sample data and expected results. it will be easier to answer.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks