Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-20-2017, 01:49 AM
GavinY GavinY is offline Look up Windows 7 64bit Look up Office 2007
Novice
Look up
 
Join Date: Mar 2017
Posts: 1
GavinY is on a distinguished road
Default Look up

Hello,
I am looking for some help with a lookup function, I have multiple data of the same value in column A, I am trying to have the data in the corresponding rows in column C displayed if I enter any of the values in column A. in a different sheet, see example.
A B C
200-0956 Wiring Loom 200-1254
200-0956 200-1312
200-0956 200-1012
200-0956 200-1311
200-0956 200-0998
200-0956 200-1255
X66070154S Tray Body T66070000S
X66070154S T66000016S

Sorry having difficulties formatting the information,
200-0956 is in A1-A6
Wiring loom is in B1
200-1254 is in C1
200-1312 in in C2
etc.



I hope that makes sense.

Last edited by GavinY; 03-20-2017 at 02:59 AM. Reason: Data format
Reply With Quote
  #2  
Old 03-20-2017, 06:32 AM
gebobs gebobs is offline Look up Windows 7 64bit Look up Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

=lookup([lookupvalue],b1:b6,a1:a6)
Reply With Quote
Reply



Other Forums: Access Forums

All times are GMT -7. The time now is 06:15 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