B
Beverly Darvill
Hi
I have 1 excel spreadsheet with several worksheets. What I need to do is to
take the value from 1 cell in one sheet look at a list of values on a second
sheet and return the value but only if there is an exact match else I need it
to return a 0. At the moment with Lookup it is returning a value that is the
closest match.
Sheet 1
Column A Column B Column C Column D Column J
sumtotal name title Code Value of Col B
from sheet 2
Sheet 2
Column A Column B
Code Value
I need it to look the value from column D in Sheet 1 and match it to the
Code in Column A on sheet 2 and return the value of Column B to Col J in
sheet 1 else return a 0
Thanks
I have 1 excel spreadsheet with several worksheets. What I need to do is to
take the value from 1 cell in one sheet look at a list of values on a second
sheet and return the value but only if there is an exact match else I need it
to return a 0. At the moment with Lookup it is returning a value that is the
closest match.
Sheet 1
Column A Column B Column C Column D Column J
sumtotal name title Code Value of Col B
from sheet 2
Sheet 2
Column A Column B
Code Value
I need it to look the value from column D in Sheet 1 and match it to the
Code in Column A on sheet 2 and return the value of Column B to Col J in
sheet 1 else return a 0
Thanks