What is the best formula to lookup and name in a column and return the entire row if the lookup name is in the 3rd column?
What is the best formula to lookup and name in a column and return the entire row if the lookup name is in the 3rd column?
Probably be best to submit a sample spreadsheet so that we can see the layout, i.e. where is the row to be returned? Also do you want to return the row number or the data from that row?
If it's the data from the relevant row you're probably best using a macro, otherwise you'd have to copy the formula across the entire row used to output the data from the original.
If I've helped please click on *Add Reputation
Yes, g1terra..
need more info..
A sample non sensitive workbook will do..
You can also refer INDEX MATCH for it..
Regards,
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
Hello g1terra welcome to the forum!
Your answer will depend if you want the results in multiple columns or just one. I took the liberty of making two different formulas to handle each situation.
LookupEntireRow.xlsx
Please click the star (add rep) if I helped!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks