searching in an array

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

Guest

How do I locate a value in an array (Ex. Check to see if B2 from sheet1
equals a value in column C of sheet 2) then return the corresponding value in
a different array if they equal ( B2 on sheet 1 equals C23 in column C, so
the returned value is the value of the corresponding value in column D, for
this example D23)?
 
enter in sheet1 cell C2
=VLOOKUP(B2,Sheet2!C1:D30,2,FALSE)

In this example the columns are only 30 cells deep
the 2 stands for the second column in the range C1:D30
 

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 to use vlookup in an array formula 2
Which Function to Use? Search an Array, Return a Row Value 1
Using Lookup with GT and LT Columns 1
Taking the Zeros out of an array when displaying 7
Returning an address from an array 6
lookup for a value in multiple columns and return a result 16
Array follow up 1
Help with data validation 1

Back
Top