This must be impossible!

  • Thread starter Thread starter thelightners
  • Start date Start date
T

thelightners

I have been trying to write a formula that will search for the occuranc
of any of the members of one field within each of the cells of anothe
field and return the value of the adjacent cell in the same row to a
arbitrary list.

Any ideas?
thanks
 
Hi!

Sounds like a VLOOKUP is what you're after but a more detailed description
would help.

Biff
 
Can you be more specific?

What do you mean by field? A column in a list/database?
You say "members". What is a member?

Please give an example of what's in the "one field" and what is in the "cells
of another field"
 
You must log in or register to reply here.

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 help separating / 2
Mapping integers to strings 5
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
resettable, over-ridable, default cell values 0
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Can a formula be "built" referencing text content from another cel 3
COUNTIFS ? 1
Counting multiple memberships 1

Back
Top