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

I have a formula which works - =IF(B2=ISBLANK(0),VLOOKUP(G2,CostCode!$A$3:$B$7,2,FALSE),B2) It basically checks to see if B2 is blank and if so uses the entry from G2. I would like it to check if B2 is blank but also to check if B2 has a text entry Project. So if B2 is blank or Project then use the entry from G2

How do I return a specific value if vlookup (or index match) contains multiple values?

I'm trying to create a IF Search combination that includes a VLookup. I can get it to return the true result, but cannot get it to return the false result.

We need to create a Vlookup. The goal is: If an address in Column H on the Streeteasy sheet is also in the Compass Sheet in Column A, then Return Columns W and X from the Streeteasy Sheet to Columns B and C on the Compass Sheet.

Currently using this formula to check a second sheet if a certain column has Category B, if so it does some math. I need to change it to if the cell has catagory B OR catagory E. I believe I need the OR statement in there somewhere, but I can't figure it out. =IF(VLOOKUP($A4:$A4,'VIP31'!$A:$E,5,FALSE)="Category B",(($F4*(VLOOKUP($A4,'VIP31'!$A:$B,2,0)%)*2%)))

I think I may need a Vlookup. Here is what we're trying to achieve: On the Streeteasy sheet - we want to have all the columns filled in each row. If there is a duplicate or several duplicates of the same address (Column H) we want to the most Recent data (Date in Column T) for each cell - so if there is an empty cell in say N2, then take the next most next most recent data in N that corresponds with the address in H. (Need this across the whole row)

I have a drop down menu of 3 options, cover only, fibre and feather. If fibre I would like to use a VLOOKUP formula, or if feather I would like to use a different VLOOKUP formula or if cover only value would be 0. VLOOKUP formula needs to relate to a size and each one would relate to a different costing table.

We need a Vlookup to complete the following task: Identify the duplicates Addresses in column H and locate the most recent (date in column T) - if there are any empty cells in that row, take the next most recent data for the same Address and replace the blank with it. The idea is to get a complete set of data for each address.

I need to vlookup particular name and check if next 2 columns has data, If both columns has data then "YES", If no "NO

I need help with if else google sheets, how to extract relevant information by using VLOOKUP, IF and other basic excel functions.