Match Text return a value from the row

D

DrewBe

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?
 
G

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

With F1 value, look at A, if match or partial match return B 5
Match value in one column and return value in same row in next col 2
Return the value from one range that does not exist in another 0
If, Lookup, Match or a combination of all 3
Compare 2 lists and return value 2
Match value return a text 6
return proper match from three columns 2
Scrabble Value calculation for Welsh words 0

Top