VLOOKUP #INVALID DATA TYPE

I'm trying to use VLOOKUP for the first time, and perhaps I just don't understand how it all works. I keep getting an "invalid data type" error. Here's my formula.

=VLOOKUP(Workorder10, {Platform MPS Range 3}, {Platform MPS Range 4}, true)

[Workorder]10 is the workorder number I'm attempting to search in the {Platform MPS} sheet. It is in the leftmost (primary) column. Range 4 is a date in the curr g2 column (which is in the 27th column) I'm attempting to retrieve from the Platform MPS sheet, and populate the VLOOKUP field with. Both columns are of the "date" type, although I get the same error even with the text/number type.

SNIP 1.JPG

Snip 2.JPG

Find more posts tagged with

Manufacturing

Formulas

Support

Comments

Mikey67156

Googlers of the future, you must select the entire range you'll be searching on the new sheet. So, in wishing to return a value from column 27, I needed to select the first 27 columns as my range on the other sheet.

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…