Get instant live Excel expert help and learn how to use an IF function with a VLOOKUP

I need help creating a formula for a vlookup with multiple IF scenarios, an example would be an Excel document with three tabs.The first tab would have a question of yes or no or a multiple-choice answer of five different products. The second tab would have our complete inventory list with indexing numbers and descriptions.The third Tab would be raw data inputted from an another Excel document that is General item type and QTY. Essentially I'm creating a pick list.

Formula in cell B6 in "AP" sheet looks at # value in A6 in "AP" sheet. This value is looked for in column I in "Data" sheet. Once value is found in "Data" sheet column I it must look at the cell left of it (same row) in column H and return the text that will be within the same row in column J in "Data" sheet only if the value "3" is true in column H. If cell value is not "3" in column H, it skips that row in the "Data" sheet and keeps looking down column I within the "Data" sheet. I am thinking it would best to use VLOOKUP and IF / ONLY IF formulas to accomplish this. I have excel files I can send to help explain if needed.

hi i want to compare two columns in excel from one cell with data from column A:A and if a second cell AB9 can be found in the second sheet in column Q:Q i need it to look up the maximal value from the 10th column - if the second value AB9 can not be found it should just show me the max value from column 10 without the second variable AB9 =MAX(IF('SAP - DATA'!A:A=I4,IF('SAP - DATA'!Q:Q=AB4,VLOOKUP(I4,'SAP - DATA'!A:L,10,FALSE),""),VLOOKUP(I4,'SAP - DATA'!A:L,10,FALSE)))

i need help with vlookup. moving data from 'ANITA'AY to 'Destination sheet'AY IF the names in column G match.

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 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")

Situation: Trying to find the right VLOOKUP formula combined with IF. Data is coming from a table in another sheet but in the same file. Tried this formula but it doesn't work. My concern, if the input/encoded data in cell G770670 can be found in: Column 1, it will show CL650 in cell X770670 Column 2, it will show G5000 in cell X770670 Column 3, it will show G6000 in cell X770670 Column 4, it will show G7000 in cell X770670 Column 5, it will show Airbus in cell X770670

I need help trying to use an if then statement while using a vlookup

need to sum cells in column B only if adjacent cells in column A are not equal. and vlookup those summed number in another tab

I'm using vlookup between two sheets in a workbook. The reference cell contains a formula that draws from a number of other cells. I get the #N/A error unless I replace the formula with the value of the formula manually. If I do that, my vlookup works as intended, but the vlookup needs to function automatically. It defeats the purpose if I have to manually enter the values in the reference field.