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

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

If the external link cannot be updated in the VLOOKUP command, where does excel get the information to put in the spreadsheet table, and how do I stop it!
Solved by A. A. in 23 mins
I have created a data Validation drop down list out of a list of companies. I would like to know if I can use VLOOKUP to auto populate a list based on the selection of a previous list
Solved by C. E. in 25 mins
problem with vlookup - the formula is working on fine. When I copy it to another cell its not working. But if I type it manually then everything is fine.
Solved by S. H. in 17 mins
This is the formula "=IF(ISNUMBER(VLOOKUP(RC[-1],NSW!C1,1,0)),NSW!R2C6,IF(ISNUMBER(VLOOKUP(RC[4],NSW!C2,1,0)),NSW!R2C7,""))" Its working fine. I have the list of states with its local holidays, I need to add a condition to this formula, for EG if = "NSW" then it refers to NSW sheet and do the above function, ROWS and Columns are same for all the states
Solved by E. A. in 26 mins
Hello! I'm having issues with a vlookup, here's the formula: =VLOOKUP(A2,Calendar!\$B\$4:\$F\$3367,5,FALSE) I can't find where 'calendar' is. the formula works but if I input a date from this october it fails. Anything before october works.
Solved by Z. A. in 30 mins
i'm trying to figure out how to combine an IF function and a VLOOKUP function
Solved by O. Q. in 14 mins
I work in a bank looking for an excel solution to a problem. On day 1 I have two identical tables filed with identical data - so A2 (and B2 and C2 etc) in table 1 = A2 (and B2 and C2 etc) in table 2. Each table has 60 columns and ~100 rows. Each of the rows represents a different company, best identified by a Client ID (a unique number that never changes) that appears in one of the middle columns. All other company information within a row can change however. Table 1 will be the most recent data (refreshed every day) and table 2 will be the hard coat version, copy and pasted from Table 1 using the previous day's data. I have a third table that compares the specific cells within each of the rows within each of the tables and uses an IF function along the lines of: If A2 in table 1 = A2 in table 2, then "OK" otherwise "Not Okay"; if A3 in table 1 = A3 in table 2, then "OK" otherwise "Not Okay" etc. On day 1, when the tables and data are identical, the same rows and cells of the same company are being compared. The problem is the live data in table 1 will include new rows of new companies that can insert themselves anywhere, which means that the company found in row A in table 1 may no longer be the same company found in row A in table 2. And I can’t just sort both tables’ data by Client ID as a simple solution as table 2 will have rows / companies that no longer appear in the live data in table 1. I've tried to work out which function I should use to match the rows of the two tables using the Client ID - maybe Index Match - but can't get it to work. In basic English the solution should be: In table 1, use the client ID in row A (or B or C or D etc) and return the row in which the same client ID appears in table 2. Once the correct rows have been matched, then compare A2 to A2, A3 to A3 etc using the IF function mentioned above. I could potentially move the Client ID all the way to the left in order to use a VLOOKUP but not sure this function will work. Please help.
Solved by M. H. in 30 mins
I have 2 sheets containing data. The first sheet is a "map" with bin locations and the second sheet contains a list of products and which bin they belong to, but the locations are separated into 4 columns.("Aisle", "Rack", "Level" and "Bay." Ideally I'd like to see if there's a way to use conditional formatting to highlight a cell on the 1st sheet if the 4 conditions for a location on the second sheet are met. This is what I've tried so far that hasn't worked: =IFERROR(VLOOKUP(“6”,Inventory!A2:A1691,1,FALSE)+VLOOKUP(“3”1,Inventory!B2:B1691,2,FALSE)+VLOOKUP(“1”,Inventory!C2:C1691,3,FALSE)+VLOOKUP(“61.1”,Inventory!D2:D1691,4,FALSE),"false") =countif((Inventory!\$K:\$K=6),(Inventory!\$L:\$L=31), (Inventory!\$M:\$M=1), (Inventory!\$N:\$N=61.1)) Help?
Solved by S. L. in 16 mins
I have created an excel spreadsheet where if there is a score between 0-10 it risk rates it accordingly 0-3 = Low Risk 3.1- 6 = Medium 6.1 - 10 = High The formula I have is the following: =IF(\$K8="n/a","Not Ranked",IF(\$K8<=MAX(\$K\$8:\$K\$244)/3,"3",IF(AND(\$K8<=MAX(\$K\$8:\$K\$244)-MAX(\$K\$8:\$K\$244)/3-1,\$K8>=MAX(\$K\$8:\$K\$244)/3-1),"2","1"))) This is probably a maths problem - and unfortunately I cannot make wholesale changes as it is linked to other parts of a spreadsheet re vlookup tables
Solved by X. B. in 28 mins