Want to compare two columns and then fill with data from the match

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two lists - one is very long, the other shorter. Every value in the
shorter colum is listed somewhere in the longer column. Long column is in
column A, short column is G. If I find a match, I then want to fill columns
H, I, J with the same information that is listed in B, C, D next to the
column A match. In other words, I have master inventory sheet with all item
information but I want to create a shorter, more often used inventory list
but I only have the item number and want to fill in the description, price
and cost without having to lookup each one and type them in.

I hope this is not too confusing and I really appreciate the help.
 
1. Please study Index and Match functions ; refer to the Help file for
details.

2. Regards.
 

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

comparing two columns revisited 1
With F1 value, look at A, if match or partial match return B 5
Data Matching 1
Matching Data 1
Excel Comparing two columns 1
Find partial text and retrun value in corresponding column 3
Lookup?? 4
Aligning Two Columns by common number 2

Back
Top