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
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.