LinkBack URL
About LinkBacks
Hi friends,
I need to CONCATENATE column A & B in sheet one and E & F in sheet two and match the result like vlookup and bring column "G" value from Sheet two to sheet one in "C" column.
Kindly help with the formula.
Regards,
Prabhu
Hi friends,
I need to CONCATENATE column A & B in sheet one and E & F in sheet two and match the result like vlookup and bring column "G" value from Sheet two to sheet one in "C" column.
Kindly help with the formula.
Regards,
Prabhu
Here, try this from C1:
Formula:
Please Login or Register to view this content.
Adjust ranges as you like.
Never use Merged Cells in Excel
Try this.. in C1
and Drag down...
Formula:Please Login or Register to view this content.
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks