if condition or array

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

Guest

Hi,
I am a little ( a lot) confused.

I want to, without using a macro, look through a range of
cells (a5-a7)for a value contained in another cell(a1).
If a match then take a range of cells and copy to another.
ie:
cell a1 = angels

the range
cell a5 = yankees
cell a6 = angels
cell a7 = mariners

Thanks
 
Hi
If you want for example 'copy' the value from column B use
=VLOOKUP(A1,A5:B7,2,0)
 
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

How can I test for nulls within a range without specifying each ce 2
grouping with vba 1
Count of visible, non-blank cells only? 8
Beginer's problemBeginner's problem 6
Colorising cells from code 4
Looking for assistance for an unusual conditional formatting probl 2
Help with a pop-up msg 5
How to delete ALL cells containing the same data 1

Back
Top