Forum Discussion
Display result base on condition
I have multiple sheets, but let's focus on only two and I'll work on the rest. The Main Sheet contains Pokemon cards that I owned. One of the columns is 'Market price'. I like the 'M...
would it be possible to do something like
IF Main["Description"] is equal to Pikachu[Name] then Main["Market Price"] = Pikachu[(Main["Graded"])
reason for Pikachu[(Main["Graded"]) is b/c we're trying to get the graded value from Main to grab the column names from Pikachu table.
Yes it is possible as you ask for, But that's gonna be a tedious work to type the formula. But still you would need PK to do this.