Forum Discussion

Ginta80's avatar
Ginta80
Copper Contributor
Jan 25, 2023

A particular date for a number

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!

Formulas and Functions
  • Juan1953DoesB's avatar
    Juan1953DoesB
    Copper Contributor
    Jan 25, 2023

    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)

     

    • Ginta80's avatar
      Ginta80
      Copper Contributor
      Jan 25, 2023
      The two tables I need to use are quite large and numbers 101 to 110 are further down in the table. I only made a small snippet of a very large document. For example purposes, if you can help with this, 101 can be 201 as well.

Share

Resources