Need a Function

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

Guest

Hi,

I need a fucntion that can lookup a value and pull out corresponding
information (that resides in multiple cells for that value) and paste that
information into one cell seperated by commas. Is there a functionthat
accomplish this?

Thanks
 
Seems a strange request - Vlookup can return a single value relating to
a fixed number of columns to the right of the lookup value, so you
could have something like this:

=vlookup(a1,table,2,0)&","&vlookup(a1,table,3,0)&","&vlookup(a1,table,4,0)&","&vlookup(a1,table,5,0)

and so on, to get you the results from the second, third, fourth, fifth
column of your table.

Hope this helps.

Pete
 

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

Excel 2007 2
Read specific time in NOW() function 2
number to character and vice-versa 8
want to track time while paste value in multiple column of same roe 1
Need Help 4
Table function 4
Lookup Function Referencing cells, not text values 3
Function to lookup largest value 2

Back
Top