Match Text return a value from the row
I have a spreadsheet with several columns. I have made a list of values that
I would like to find in the spreadsheet from a specific column (Column D). I need to return the values from Column B if Column D value matches the value from my list. Can someone help me with finding a function to produce this logic? |
Match Text return a value from the row
Say cols B & D contain:
994-24-6935 James Smith 164-42-7902 John Johnson 160-51-4133 Robert Williams 697-15-8450 Michael Jones 416-88-7799 William Brown 491-79-2134 David Davis 805-78-1171 Richard Miller 271-13-3137 Charles Wilson 611-73-7500 Joseph Moore 768-47-4953 Thomas Taylor 710-18-2927 Christopher Anderson 586-97-2716 Daniel Thomas 107-27-9723 Paul Jackson 940-67-2563 Mark White 201-81-6046 Donald Harris 143-16-9002 George Martin 164-30-1711 Kenneth Thompson and F1 thru F3 contains: Michael Jones Thomas Taylor Mark White In G1 enter: =OFFSET($B$1,MATCH(F1,D$1:D$17,0)-1,0) and copy down. We see in cols F & G: Michael Jones 697-15-8450 Thomas Taylor 768-47-4953 Mark White 940-67-2563 -- Gary''s Student - gsnu200860 "DrewBe" wrote: I have a spreadsheet with several columns. I have made a list of values that I would like to find in the spreadsheet from a specific column (Column D). I need to return the values from Column B if Column D value matches the value from my list. Can someone help me with finding a function to produce this logic? |
Match Text return a value from the row
See this:
http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "DrewBe" wrote in message ... I have a spreadsheet with several columns. I have made a list of values that I would like to find in the spreadsheet from a specific column (Column D). I need to return the values from Column B if Column D value matches the value from my list. Can someone help me with finding a function to produce this logic? |
All times are GMT +1. The time now is 09:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com