Friday, October 07, 2005
Excel Function
Yes, that's right, I am posting a question about a purely business related topic. I need help creating a function for Excel 2003. Here's the scenario:
I need to take a value in a cell from one spreadsheet (A) and compare it to a column on a second spreadsheet (B) to see if one of the cells in that column is a match.
If a match is found, I need the function to then access a value of a cell in another column in spreadsheet B and copy the value of that cell to a blank cell in spreadsheet A. If no match is found, I need the blank cell in spreadsheet A to read "No Match".
C'mon geeks, help a yuppie out.
|
I need to take a value in a cell from one spreadsheet (A) and compare it to a column on a second spreadsheet (B) to see if one of the cells in that column is a match.
If a match is found, I need the function to then access a value of a cell in another column in spreadsheet B and copy the value of that cell to a blank cell in spreadsheet A. If no match is found, I need the blank cell in spreadsheet A to read "No Match".
C'mon geeks, help a yuppie out.
|
Read my Dreambook guestbook! Sign my Dreambook! |
|