Excel formulae to numbers

Hi Wildoh

Numbers does support VLOOKUP. Take a look at this link and scroll to Lookup and Reference Functions

https://www.apple.com/mac/numbers/compatibility/

VLOOKUP is fully supported.

Or, take a look at this link:

Formulas and Functions Help https://help.apple.com/functions/mac/9.1/

Scroll to see Reference functions. Click on VLOOKUP. Here is a quote from that Help file:

The VLOOKUP function returns a value from a collection of columns by using the left column of values to pick a row and a column number to pick a column in that row.

VLOOKUP(search-for, columns-range, return-column, close-match)

search-for: The value to find. search-valuecan contain any value.

columns-range: A collection of cells. columns-rangemust contain a reference to a single rangeof cells, which may contain any values.

return-column: A number value that specifies the relative column number of the cell from which to return the value. The leftmost column in the collection is column 1.

close-match: An optional modal value that determines whether an exact match is required.

close match(TRUE, 1 or omitted): If there’s no exact match, select the row with the largest left-column value that is less than or equal to the search value.If you use close match, you can’t use wild cardsin search-for.

exact match(FALSE or 0): If there’s no exact match, returns an error.If you use exact match, you can use wild cards in search-for. You can use the wild card ? (question mark) to represent one character, an * (asterisk) to represent multiple characters, and a ~ (tilde) to specify that the following character should be matched rather than used as a wild card.

Sorry for the long lecture, but Excel and Numbers have different concepts of "tables".

If you tell us your overall aim, we will have a better understanding. What are you trying to do? Perhaps we can suggest other ways to achieve your outcome.

Regards,

Ian

Hi Wildoh,

The Numbers way. Individual tables on a background "canvas". Each table has a purpose.

Cell A1 in the "Choose a fruit" table is a Pop-Up Menu created from column A of the "In Stock" table.

Formula in cell A2 of the "Choose a fruit" table =VLOOKUP(A$1,In Stock::A:B,2,FALSE)

A frequent reply from fellow users in Apple Support Communities is: "If you tell us your overall aim, we will have a better understanding. What are you trying to do? Perhaps we can suggest other ways to achieve your outcome."

Please reply and tell us your overall aim.

Regards,

Ian.

As Ian points out VLOOKUP works the same in Numbers as in Excel. But document structures can differ. Unlike in Excel, Numbers sheets don't have cells. They are a blank canvas on which you can place tables and other objects. It's the tables that have cells. Numbers does its best to open and import Excel documents but adjustments are usually necessary. Exactly what adjustments are needed depends on the specifics of your document, which you haven't provided.

BTW, Excel has a good iPad version. Have you tried it? It might be a better solution for you.

SG

Hi Wildoh,

Please don't keep us guessing! What is the vlookup formula? What is your overall aim? Some context will help us to understand.

Regards,

Ian.