Logical function combination

**Arquiterco** · 05-31-2011, 10:43 PM

Hi, good day everyone...

I'm trying to build one spreadsheet with two workbooks.
Right now my advance it's from 80%; but I'm stuck with the next formulas:

I require to combine them.

=IF(E28=VLOOKUP(E28,$U$2:$U$14,1,0),$D$28*VLOOKUP(E28,$U$2:$V$14,2,0),0)
=IF(E28=VLOOKUP(E28,$U$15:$U$26,1,0),$D$28+VLOOKUP(E28,$U$15:$V$26,2,0)," ")

so far so good this formulas work pretty good, but when I combine them i can't make them work.

=IF(E28=VLOOKUP(E28,$U$2:$U$14,1,0),$D$28*VLOOKUP(E28,$U$2:$V$14,2,0),IF(E28=VLOOKUP(E28,$U$15:$U$26,1,0),$D$28+VLOOKUP(E28,$U$15:$V$26,2,0)," "))

i had try several formulas; and the above one, that only works partially.

**NBVC** · 05-31-2011, 10:50 PM

Try:

Please Login or Register  to view this content.

**Arquiterco** · 05-31-2011, 11:25 PM

Thanks, this formula works. that formula solve the issue.

**Joy_Joy** · 09-12-2012, 05:43 AM

Hi,

I am trying to lookup J3 to see if it is also in the VSN spreadsheet and if it is there, then pull it into the current spreadsheet. However, if it is not in the VSN spreadsheet then, the use the original value/word in J3.

The logical function works if the item is in the VSN spreadsheet, but I get N/A# when it is not. I have formatted the columns as numbers even if they contain text.

Can someone please help?

=IF(J3=(VLOOKUP(J3,'VSN with ID#s'!$A$1:$C$79,1,FALSE)),VLOOKUP(J3,'VSN with ID#s'!$A$1:$C$79,3,FALSE),J3)

**arlu1201** · 09-12-2012, 06:01 AM

Joy_Joy,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.