Hi, 

Im new to excel and trying to solve some issues. I want to get something and i could do this with IF+vlookup function but the cell that I want to get the data from is on the left. As per my understanding, vlookup only able to do the right side cell. 

Basically, I want to have the table on the left filled with the information on the right table with several condition such as I only want to take the week from 7/1 to 7/8 so i used =date-7. So, Unit 405 shouldnt move to the ‘leases’ table. 

I used if vlookup because the only think i can think is to vlookup the date, but how to get the unit, floorplan, etc info if using vlookup this way? 

Thank you! 

​Hi,  Im new to excel and trying to solve some issues. I want to get something and i could do this with IF+vlookup function but the cell that I want to get the data from is on the left. As per my understanding, vlookup only able to do the right side cell.   Basically, I want to have the table on the left filled with the information on the right table with several condition such as I only want to take the week from 7/1 to 7/8 so i used =date-7. So, Unit 405 shouldnt move to the ‘leases’ table.  I used if vlookup because the only think i can think is to vlookup the date, but how to get the unit, floorplan, etc info if using vlookup this way?  Thank you!   Read More

​