Forum Discussion
Ginta80
Jan 25, 2023Copper Contributor
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 formul...
Juan1953DoesB
Jan 25, 2023Copper Contributor
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)
- Ginta80Jan 25, 2023Copper ContributorThe 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.
- Juan1953DoesBJan 25, 2023Copper Contributor