In my spreadsheet, I'm looking to match up data from Sheet 1 to Sheet 2. I'd like Sheet 2 to list the 4 names from sheet 1 based on the number given to the name in Column K. Cell C4 in sheet 2 should read Joe and so on and so forth. I'm sure this is an easy formula just learning how it all works. Thanks for your help!
Try this formula in C4 of Sheet2 and fill down:Formula:
Please Login or Register to view this content.
On C4 (Sheet2) and copied down:
=INDEX(Sheet1!$C$4:$C$7,MATCH(B4,Sheet1!$K$4:$K$7,0))
or
=VLOOKUP($B4,CHOOSE({1\2},Sheet1!$K$4:$K$7,Sheet1!$C$4:$C$7),2,0)
Last edited by azumi; 02-03-2015 at 12:14 AM.
In C4 cell of Sheet2
=INDEX(Sheet1!$C$4:$C$7,MATCH(B4,Sheet1!$K$4:$K$7,0))
Drag it down...
If you want to show personalized message when the value does not found in the source list then use IfError() like this...
In C4 cell of Sheet2
=IFERROR(INDEX(Sheet1!$C$4:$C$7,MATCH(B4,Sheet1!$K$4:$K$7,0)),"Not Found In Source")
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hello again...
Try this in C4 `
Please Login or Register to view this content.
Last edited by GC Excel; 02-03-2015 at 12:14 AM. Reason: typo in formula
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Perfect thanks everyone!!
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks