Using IF, AND, and IF together

  • Thread starter Thread starter Natasha
  • Start date Start date
N

Natasha

I need to have it search a column, and if that column has
the correct information, go to another column in the
worksheet?

Can anyone help me with this? I have gone to all of the
usual suspects.

Thanks!
 
Have you looked at VLOOKUP, eg:-

=vlookup(lookup_value,table_array,col_index_num,range_lookup)

With a 10 column range named Data, and a value in say Z1 that you want to look up in the leftmost
column of Data and then if a match is found, bring back the value in the 5th column of the range
Data

=VLOOKUP(Z1,Data,5,0)

The 0 at the end dictates an exact match must be had to return any data.
 
Back
Top