Return a cell refernce based on a value

  • Thread starter Thread starter Number_8
  • Start date Start date
N

Number_8

I have a value in worksheet A which is "x". In worksheet B column A
have a list of values i.e. a,b,c,d...x,y,z and in column B I hav
values relating to those in coumn A i.e. column A row 1 value is "a
column B row 1 value is "apple", column A row 2 value is "b" and colum
B row 2 value is "balloon", how do I get teh first worksheet to rea
the value in one cell, find it in column A of the other worksheet an
give back the value on teh same row in column B?

Thank
 
Hi

use the VLOOKUP function

=VLOOKUP(lookup_value,table_array,column_number,true_or_false)
or in english
=VLOOKUP(the thing in both places, the table that's got the answer, the
actually column # of the column in the table with the answer,true - for
approx match / false - for exact match)

if the value i wanted to find in sheet2 was entered in cell A1 and i wanted
the associated value from sheet2 column b the formula would go something
like this:

=VLOOKUP(A1,Sheet2!$A$1:$B$20,2,true)

check out help for more details

Cheers
JulieD
 
Keep both sheets open and use the VLOOKUP command.

=VLOOKUP(A1;sheetB!A1:B10;2;0)

regards,
Arien N
 
Back
Top