Can someone breakdown the formula for me? I tried to understand from the topics but could not figure it out.
I have also looked VLOOKUP vs findrow but did not understand.
I am trying for something like below:
=VLOOKUP("Data from table1","Table2","2",FALSE)
Hey @Dodge thank you for your question! For this particular case the FindRow might look something like:
=FindRow(Table2, "Table2[Second columns header]=%", [column header for the source data from table1 you want to use])
Happy to make this more concrete if you're able to share screenshots of Table, Table2, and the actual vlookup you're looking to write without sharing personal information.