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

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

Solved by M. A. in 15 mins

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

Solved by D. E. in 13 mins

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.

Solved by D. J. in 14 mins

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.

Solved by I. H. in 18 mins

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

Solved by X. W. in 25 mins

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)

Solved by G. F. in 15 mins

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.

Solved by K. A. in 30 mins

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.

Solved by C. B. in 28 mins

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

Solved by T. J. in 17 mins

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

Solved by O. C. in 27 mins