MrExcel Publishing
Your One Stop for Excel Tips & Solutions

nesting formulas


Posted by s barr on July 10, 2001 9:01 PM

I am attempting to move information from one worksheet to another (right now I'm doing one cell at a time).

Basically, here's what I need for a formula to do, but can't get it worked out.

I need to do a vlookup on one worksheet, have it find the exact matching data, then look in another column (next to the exact matching information)to see if that cell has a specific text in it. If the specific text is
there, then I need the formula to return the text in the next column. Is
this possible?

I can get the vlookup to work and the =if statement to work, but cannot join
the two formulas.

Thanks in advance for your help.

S Barr


Posted by Aladin Akyurek on July 10, 2001 9:14 PM

Care to post both formulas? Even if they are wrong, they will provide additional info which would help.

Aladin

Posted by IML on July 11, 2001 7:33 AM

A guess

How about something along the lines of:
=IF(VLOOKUP(A1,Sheet2!$A$2:$C$4,2,FALSE)="YES",VLOOKUP(A1,Sheet2!$A$2:$C$4,3,FALSE),"")
this assumes you have a three column list on sheet two and enter the name or search item in A1 on the current sheet.
With this formula if you name or search item has a "yes" next to in column 2, it will return the value of column 3. If it does not match, it will return a blank "".

If this isn't close, some more info such as Aladin suggested would be helpful.

Good luck.