Get instant live Excel expert help with VLOOKUP functions

Trying to use a vlookup google sheets to reference other sheets, and cannot get it to return the proper value. =VLOOKUP(D2,IMPORTRANGE("107Hi2GkEm3nzv6DD3wWKbnR5_kCADhhy4M5AQJ1mGB8","Sheet1!E2:E2000"),IMPORTRANGE("107Hi2GkEm3nzv6DD3wWKbnR5_kCADhhy4M5AQJ1mGB8","Sheet1!B2:B2000"))

I need help with a few formulas on a spreadsheet I'm working on. 1.) It seems like excel is counting the blank spaces in row F whenever the data drop tab is blank. Is there a way to set this to "0" instead? 2.) I believe I am trying to do a VLookup formula, but I'm not very familiar with it. I am trying to set it so the sheet will copy the employee's name to a separate list based on if they meet certain criteria.

I have a table that plots college courses (along y-axis) against possible General education requirements (along x-axis). I need to write one function that I can copy to all cells so that if the given course meets one or more requirements, it will put an X i the corresponding cell or cells. In another worksheet the information is plotted with the course listed as many times as it has requirements with one requirement written next to it. I would use vlookup, but since there are duplicate courses in the data table that lists what requirement each course meets, it does not work

I need help creating a VLOOKUP table. I am requesting that i could use the same expert as before, as they already have some information on my problem.

Hi, I need help on a VLOOKUP table. I am requesting the same expert i had before as they know more about the problem than i care to explain again. Thank you

Hi, i need help on a VLOOKUP. I am requesting the same one as before as they know more information about my specific problem.

Hi, I need help with a vlookup table. I will add the file as soon as i am matched with an expert as the last file i added was corrupt.

Need help with a VLOOKUP table. Boss asked me to sort grades in the table. Will input data in the session.

Hello. I have been searching for a way to do this and don't even know the right questions to ask. I have always been able to figure things out without help, except Google, but this has me stumped. What I am trying to do is develop a plant database that will show all plants I will be installing for a client's project and what I'd like to do is have the details auto-populate based on the input of a selected plant. Things like harvest dates, fertilizer recommendations, annual or perennial, water requirements, etc. I'll attach some screen shots. I have spent 4 hours trying to figure this out. I've tried IF & VLOOKUP and I don't know what else to do. I can make a data sheet for each plant variety or a table but I can't figure it out at all. I know I don't expect anyone to do the work for me, but if you could just point me in the right direction, I'd sure appreciate it! Thanks.

Pulling data from one sheet from another with either vlookup, index, or if then?