Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-03-2011, 12:54 PM
pdfaust pdfaust is offline Need to search a column for a macth and return a result from a third column Windows 7 32bit Need to search a column for a macth and return a result from a third column Office 2007
Novice
Need to search a column for a macth and return a result from a third column
 
Join Date: Feb 2011
Posts: 2
pdfaust is on a distinguished road
Default Need to search a column for a macth and return a result from a third column

I have a list of about 3000 entries to sort. Basically each person will always be a lead on a job and almost always be a backup on another job. I need a formula in column a that will look at the data in column b, search for a match in column c and then return the value from column d - if there is no match it would state that or na is acceptable. Would anyone have any ideas on this?

Thank you
Attached Files
File Type: xls sorting issue.xls (15.5 KB, 16 views)
Reply With Quote
  #2  
Old 02-03-2011, 02:51 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Need to search a column for a macth and return a result from a third column Windows 7 32bit Need to search a column for a macth and return a result from a third column Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi,

If I understand correctly, put this formula in A2 and then fill down:

Code:
=VLOOKUP($B2,$C$2:$D$6,2,0)
Hope that helps...
Reply With Quote
  #3  
Old 02-03-2011, 03:02 PM
pdfaust pdfaust is offline Need to search a column for a macth and return a result from a third column Windows 7 32bit Need to search a column for a macth and return a result from a third column Office 2007
Novice
Need to search a column for a macth and return a result from a third column
 
Join Date: Feb 2011
Posts: 2
pdfaust is on a distinguished road
Default Thank you that worked

Thanks that 2 in the string was messing me up, I see how it works now. I did not have my array to include that row in the search.

Thank you so much,
Phil
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo Box in whole column ioustinos Excel 1 09-01-2010 01:24 AM
Need to search a column for a macth and return a result from a third column Column width markg67 Word 2 06-07-2010 07:40 PM
Need to search a column for a macth and return a result from a third column magazine column style Nasser Word 4 04-21-2010 02:41 PM
Need to search a column for a macth and return a result from a third column From Excel column to coma saatfj Excel 2 04-15-2010 09:59 PM
Need to search a column for a macth and return a result from a third column Last Number in a Column paulrm906 Excel 1 12-05-2008 07:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft