Forum Discussion
Vlookup and return entire row from another sheet
Maeby While this can be accomplished with VBA, if you're in the Insider program, you can use the FILTER() function.
If your data in Sheet2 is in rows A:BB, and there are 260 rows on that table, and you were trying to use a value in B3 to perform the lookup, the formula would be:
=FILTER(Sheet2!$A$2:$BB$260,Sheet2!$A$2:$A$260=B3,0)
This formula says to return all rows (from the table in Sheet2) where the values in column A equal the value in B3.
Unfortunately, this feature is only currently available with the insider program in O365, but this is the way that the formula would work!
Maeby While this can be accomplished with VBA, if you're in the Insider program, you can use the FILTER() function.
If your data in Sheet2 is in rows A:BB, and there are 260 rows on that table, and you were trying to use a value in B3 to perform the lookup, the formula would be:
=FILTER(Sheet2!$A$2:$BB$260,Sheet2!$A$2:$A$260=B3,0)
This formula says to return all rows (from the table in Sheet2) where the values in column A equal the value in B3.
Unfortunately, this feature is only currently available with the insider program in O365, but this is the way that the formula would work!
Still working on learning VBA but in the meantime, this was a great answer that will save me loads of time, thank you! I'll re-sign (odd word in this context) to the insider program and give it a shot! macrordinary