Help with a formula please
 

Help please... I have a worksheet with rows and rows of data (text) in one
column. For each row in the next column I need to write a formula that looks
at the corresponding value in the first column and looks it up in a list on
worksheet 2. If it finds it in the list on worksheet 2 then return a value
which is in the next column (same row) on worksheet 2.

example
column 1, row 1 on worksheet 1 value = "GP"
formula checks through a list of 15 values on worksheet 2 and finds the
value "GP" in column 1, row 8. It returns value from column 2, row 8 which =
16 and displays it in column 2, row 1 on worksheet 1.

Thanks in anticipation!!

One way:


=IF(ISNA(MATCH(A1,Sheet2!A:A,FALSE)),"",VLOOKUP(A1 ,Sheet2!A:B,2,FALSE))


In article ,
"nackington" wrote:

Help please... I have a worksheet with rows and rows of data (text) in one
column. For each row in the next column I need to write a formula that looks
at the corresponding value in the first column and looks it up in a list on
worksheet 2. If it finds it in the list on worksheet 2 then return a value
which is in the next column (same row) on worksheet 2.

example
column 1, row 1 on worksheet 1 value = "GP"
formula checks through a list of 15 values on worksheet 2 and finds the
value "GP" in column 1, row 8. It returns value from column 2, row 8 which =
16 and displays it in column 2, row 1 on worksheet 1.

Thanks in anticipation!!

Thanks JE... works great.....!

"JE McGimpsey" wrote:

One way:


=IF(ISNA(MATCH(A1,Sheet2!A:A,FALSE)),"",VLOOKUP(A1 ,Sheet2!A:B,2,FALSE))


In article ,
"nackington" wrote:

Help please... I have a worksheet with rows and rows of data (text) in one
column. For each row in the next column I need to write a formula that looks
at the corresponding value in the first column and looks it up in a list on
worksheet 2. If it finds it in the list on worksheet 2 then return a value
which is in the next column (same row) on worksheet 2.

example
column 1, row 1 on worksheet 1 value = "GP"
formula checks through a list of 15 values on worksheet 2 and finds the
value "GP" in column 1, row 8. It returns value from column 2, row 8 which =
16 and displays it in column 2, row 1 on worksheet 1.

Thanks in anticipation!!