listing matches

M

Maadmaxx

Joined
Mar 7, 2006
Messages
1
Reaction score
0
I'm using the formula:

=IF(ISNA(MATCH(F51:AF52,'Data Sheet'!A4:A103,0)),"",VLOOKUP(C51,'Data
Sheet'!A4:B103,0))

Each of the numbers in 'Data Sheet'!A4:A103 have a text description in column B. What I would like it to do is place the matching text in column B into a cell for every match it finds. The way it is now, it only lists the last match from column A and its corresponding text. Any ideas as to how this can be done? Thanks for looking in here.....Maxx
 

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

Payroll sheet comparisons 11
If at first you don't suceed... 4
Comparison of columns using Conditional Formatting 3
Creating a dynamic IF statement 2
If and Vlookup 3
Match and Vlookup issue 2
Multiple criteria search 2
if statements for multiple entries 1

Top