Solved Excel Formula for matching data

March 19, 2012 at 14:28:13
Specs: Windows XP
Data in Column A1 through D50. I want Column E to find and return data from columns A1-A50 and find matching data in C1 thru C50. I need the corresponding data next to each cell from A1-A50, that is entered in cell B1 through B50 and the same with columns C1-C50 with data that is in D1-D50 and enter into Column F. Example:
A B C D E F
123 $25.14 671 $16.50 671 $16.50
671 $16.50 789 $10.25 123 $25.14
554 $90.00 123 $25.14

See More: Excel Formula for matching data

Report •

#1
March 19, 2012 at 15:52:53
✔ Best Answer
Please click on the following line and read the instructions on how to post data in this forum...then repost your example data.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
March 20, 2012 at 06:31:38
Data in Column A1 through D50. I want Column E to find and return data from columns A1-A50 and find matching data in C1 thru C50. I need the corresponding data next to each cell from A1-A50, that is entered in cell B1 through B50 and the same with columns C1-C50 with data that is in D1-D50 and enter into Column F.

Example:

 A     B    C   D      E     F
123 $25.14 671 $16.50 671 $16.50
671 $16.50 789 $10.25 123 $25.14
554 $90.00 123 $25.14

edited by moderator: Moderator edit: Fixed Formatting


Report •

#3
March 20, 2012 at 06:36:32
Read the Excel Help files (or Google) for the VLOOKUP function.

That function should return the results your are looking for.

Posting Tip:

The pre tags should only go around your example data, not around the text of your question.

I have edited your post to fix the problem.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question