Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Expressions: vlookup with string index #2996

gdm120 started this conversation in Ideas
Discussion options

I have string index for the table(eg ticker) so only col() function works for me.
It would be convenient to have vlookup(), index() with string support.

You must be logged in to vote

Replies: 1 comment

Comment options

index() and vlookup() already work with strings:

const table = await worker.table(superstore, {index: "Order ID"});
const view = await table.view({
 expressions: {
 "vlookup test": "vlookup('State', 'CA-2016-152156')",
 "index test": "index()"
 }
})
Screenshot 2025年05月23日 at 12 53 57 AM
You must be logged in to vote
0 replies
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Ideas
Labels
None yet
2 participants

AltStyle によって変換されたページ (->オリジナル) /