VLOOKUP #INVALID DATA TYPE Challenge

11/19/19 Edited 12/09/19

Hi!  I'm new to the community and already raising an issue.  Sorry about that!  If anyone can help me with this, I'd greatly appreciate it. 

I'm trying to use VLOOKUP within a Product Roadmap sheet to set the values of the feature start date and end dates based upon a Sprint it is assigned to, referencing a set of scheduled sprints lower in the sheet.  A simplified example sheet demonstrating the problem using the standard template as a starting point is attached.

The function looks correct to me, but it continuously throws a #INVALID DATA TYPE error in the cell.  The lookup column and value cell are both set to "Date" and are actually the exact same column, so I'm not clear why there would be an error from this.  

Second attachment shows an example function being used.

Again, any thoughts are greatly appreciated!

 

VLOOKUP_2.png

VLOOKUP_1.png

Comments

  • Mike WildayMike Wilday ✭✭✭✭✭
    edited 11/19/19

    From the looks of your vlookup it looks like your formatting might be off. You should have, the search value, the range to look up, the column number you want to return, and whether or not you want an exact match (false = exact match, true = approximate match). 

    https://help.smartsheet.com/function/vlookup

    Try this formula... =vlookup([email protected], $Sprint$16:$[Start Date]$22, 3, False)

    Does that produce the result you are looking for? 

  • Yep, that fixed it.  Thanks Mike!  Time to go fire up the coffee machine...

    blush

  • Mike WildayMike Wilday ✭✭✭✭✭

    Drink an extra-strong one for me! Glad I could help you get it working! 

    yes

Sign In or Register to comment.