G
Guest
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!!
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!!