Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-24-2016, 01:31 PM
lonniepoet lonniepoet is offline Cross-reference / lookup data from one tab and display on another - How to Windows 7 32bit Cross-reference / lookup data from one tab and display on another - How to Office 2013
Advanced Beginner
Cross-reference / lookup data from one tab and display on another - How to
 
Join Date: Dec 2015
Location: Kansas City
Posts: 41
lonniepoet is on a distinguished road
Default Cross-reference / lookup data from one tab and display on another - How to


Greetings. I have two spreadsheets that were created before I started and my customer has now requested that all the data be on one spreadsheet. I have them as separate tabs on the same file, but would like them on one sheet without doing a lot of back and forth manual entry work (my assistant is busy with other tasks and I simply don’t have the time). I was wondering if there is any way to look-up the fields for Columns C-E on the second tab ‘Purchase Order Log’ and display them on the first tab ‘Catalog Master Copy’. I tried messing around with the VLOOKUP function, but keep coming-up empty-handed or riddled with error messages. There are several items that may not be capable of cross-referencing. As in, an item may be on the first tab that is not on the second one and vice-versa. I originally thought that the SKU# would be a good variable to use for cross-referencing, but there are several instances on the second tab (the PO Log) where the same SKU# us listed multiple times with different PO#’s and VCD dates. Any help or advice would be much appreciated. I will log in later today to follow-up. Thank you all in advance for the assistance.
Attached Files
File Type: xlsx Catalog Info.xlsx (169.2 KB, 8 views)
Reply With Quote
Reply

Tags
cross reference, formula help, lookup

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
cross-reference to field eNGiNe Word 1 02-27-2015 07:46 PM
Cross-reference / lookup data from one tab and display on another - How to Formulas/Scripts That Cross Reference & Import Data ekeithjohnson Excel Programming 3 08-23-2014 11:26 PM
Cross-reference / lookup data from one tab and display on another - How to Reference number and cross reference for equation numbers to match the thesis format wmac Word 1 05-14-2013 08:54 PM
2 figures cross reference mmdmov Word 0 05-05-2010 09:12 AM
How do I return from a cross reference? smoggymark Word 0 10-21-2008 07:45 PM

Other Forums: Access Forums

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