Get instant live Excel expert help with VLOOKUP formula

Please review the enclosed EXCEL file: The formula I have entered{ VLOOKUP(B2,Candidates!$A$2:$B$606,2,FALSE)} on the column I of the Sheet (SUBJECT1) returns AN ERROR MESSAGE (#N/A). How do I solve the problem???

Fixing Formulas DESCRIPTION: I need a formula that looks into an array and if in that array it has one of the following: TCO302, TCO332, TCO333, then it returns an X in that excel file. Below is the formula I am trying to make work: =IFERROR(IF(N819="X","X",INDEX(Data!$N$2:$N$2000,MATCH(1,(Data!$B$2:$B$2000=B819)*(ISNUMBER(MATCH(Data!$I$2:$I$2000={"TCO302","TCO332","TCO333"},0))),0))),"") My last gotitpro suggested the following formula but our time, time out: :=IF(OR(VLOOKUP(B5,B122:I135,8,0)="TCO302",(VLOOKUP(B5,B122:I135,8,0)="TCO332")),"X","")

I need to correct a complex formula, I am getting an error. It includes a vlookup, if, and iferror

I have an error in a vlookup formula that is combined with a an iferror. I need help fixing it

I need an excel formula written that will take a number, find it in another list, and if found, do a vlookup to a cell in the first spreadsheet, and lookup the value in another column only if the number is in the first column.

I need help with a formula, I have written one but need to add something else on and just can't seem to work it out? The formula in M9 is:=IF(OR(L9="No Date",L9="Enter Date Here!",L9="-"),"",SUM(L9,730)), What i'm asking is if any of the text is entered in cell L9 then cell M9 will be blank and just do the sum, however I now want to change it, if L9 says "No Date" then M9 displays "Not required". I have another formula in L9 already, which is:=If(ISNA(VLOOKUP(D9,Inputs!S:AE,9,false)),"-",VLOOKUP(D9,Inputs!S:AE,9,false)) this is carrying information across from another sheet. Help???

I need help with my formula, got stuck with it! "That's the formula" =IF(D8="No Checklist",IFERROR(IF(and(VLOOKUP("*"&C$2&"*"&$A7&"*",BIM!$A:$D,1,false),VLOOKUP("*"&C$2&"*"&$A7&"*",BIM!$A:$D,2,false)="Open"),VLOOKUP("*"&C$2&"*"&$A7&"*",BIM!$A:$D,3,false),""),"0%"),"Closed")

create a formula using the IF and VLOOKUP functions to calculate the rental charges for each set of furniture based on the furniture’s group code, the rental period and the Furniture Rental Charges table,For the IF function arguments, use one VLOOKUP function for the 6-months and another VLOOKUP function for the 12-months alson column I, enter a formula to calculate the insurance charge if the renter has elected insurance coverage. Use the furniture’s group code and the Monthly Insurance column in the RentalCharges table to look up the insurance charge. If the renter has not elected insurance, the cost is $0.

I have to use VLOOKUP for my assignment in class, and she gave me no explanation on how to do it (online class) and the book doesn't explain it. I don't know how it works or what to do... All the instructions say are "To determine which clothing lines may sell well online, you decide to rank them on a scale from A to E. In cell H5, using a Vlookup function, determine the product line ranking of each product based on the Yearly Sales. Use the range name assigned to the lookup table. Copy the formula through H16"

VLOOKUP containing INDIRECT reference is not working correctly. Please find the formula in cells F5:F on sheet "TermData".