An Iconic Fantasy Baseball Community
Moderator: Baseball Moderators
This formula would take the value in B2, and search the entire TF2 tab, starting from cell A1 - G2881, move
Bloody Sox wrote:This formula would take the value in B2, and search the entire TF2 tab, starting from cell A1 - G2881, move
See, the problem is that VLOOKUP only searches in the first column of the range specified, not all columns. So in your case, it'd only lookup the B2 value in Column A, not in Columns B-G.
My problem is that I don't know which of the columns in the table my data is in.
Bloody Sox wrote:I just need to know if the string value I'm looking up lives in that table or not.
Users browsing this forum: Majestic-12 [Bot] and 3 guests