VLOOKUP
I know how to use VLOOKUP to find data on a different worksheet. I enter
my search criteria on my VLOOKUP worksheet, it goes to the other worksheet,
finds the critera and returns the data I'm looking for.
My question is: Using the VLOOKUP worksheet and returned data, can I
change the returned data on the searched worksheet.
For example:
I have a worksheet with my VLOOKUP criteria established. I look for a part
number on a different worksheet. If that part number is found, the APL,
COG, MCC, and NIIN information are returned.
I need to change the APL, COG, MCC, and NIIN on the worksheet that was
searched. Is there a way I can do this from my VLOOKUP worksheet.
For example, if the APL information that was returned was "000A3333", can I
change that to 000A9999 from my VLOOKUP worksheet?
I'm not sure this is clearly explained. I hope so.
I'm thinking that I need to have a separate worksheet that goes into the
other worksheet, finds the data I looking for and replaces selected data.
For example, I need a worksheet that searches for 123456 on a separate
worksheet and if it finds it, the APL is changed from 000A3333 to 000A9999
Any help would be appreciated.
|