Jan 25 2023 08:11 AM
Hi everyone,
I am fairly new to VLOOKUP formulas and I need your help.
I need a formula that designates a date from two charts for a number in a column.
I have a suite number and I need the formula in the firm occupancy column/cell to be reading from two different boxes where different suite numbers have dedicated dates.
A little snippet from the chart i need to create:
Please help!
Jan 25 2023 11:37 AM - edited Jan 25 2023 12:22 PM
I don't see the numbers 101-110 anywhere in the table
I don't know if this is the intention, but otherwise you have to use a different formula
=VLOOKUP(F5,J4:K19,2,FALSE)
Jan 25 2023 11:49 AM
Jan 25 2023 01:56 PM - edited Jan 26 2023 04:33 AM