IF/THEN FORMULA question--CHALLENGING

Posted by Celeste on January 25, 2001 2:52 PM

i'm trying to create an if/then formula that states the following:

IF B1 (from 1st excel sheet)= any one number in 2ND Excel Sheet from C11:C50 THEN = 2nd excel sheet column Dwhatever line number was equal to c before

i hope i wrote that out legibly. i'm not very familiar at all with code, just formulas. so if you could please assist me with the formula, that would be great. the only part of the formula i need help with is:

=IF(B1=[2NDEXCELSHEET!$C$11:$C$50,???????????????

thank you for your help in advance

Posted by Wayneo on January 25, 2001 4:22 PM

Hello Celeste,

Try this out: on "Sheet1" in an open cell place this formula =VLOOKUP(B1,Sheet2!C11:D50,2,0)

This will look at the value in B1 of "Sheet1" and attempt to find the corressponding value on "Sheet2" within the range C11:C50. The "2" in the formula will return the value in "D" of "Sheet2".

Make sure you sort your data on "Sheet2" Column C in ascending order. Let me know if this helps you out.