Hi,
I want to lookup the value A2 in column C (see attached file), when it finds that value I want to return the whole row and not just one cell.
If it was one cell only, it's easy to achieve with VLOOKUP or INDEX/MATCH but I want the entire row as already mentioned above.
Thanks in advance for having a look at this !!!
Use this in C18 and extend to the right:
Formula:
Please Login or Register to view this content.
Could you maybe just fill the vlookup formula to the right and change the column value?
=VLOOKUP($A2,$C$3:$G$10,1,FALSE)
In the first cell
=VLOOKUP($A2,$C$3:$G$10,2,FALSE)
In the second, and so on.
Hi Kingdomcome82 and zbor,
Both are working fine. Thank you for the quick response. Much appreciated !!!!
Have a good one.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks