Vlookup, copy only certain values
I"d like to use a vlookup function,that is part of macro, will return certain
values to the next column. Example, only Green and Red value is copied on the column B from column A. column A Column B Green Green Brown Brown Green Green Red Red Red Red Black Red Red Wonder if anyone could help me. Thanks, Aline -- Aline |
Vlookup, copy only certain values
Hi Aline
Hmmm, I'm not getting full understanding of what you're doing. What do you really want to do? Can't you place an IF-function in column B? (with or without VBA-code). Or do you (want to) use the Find method programmed in VBA (the VBA counterpart of Ctrl-F). So, a bit more detail please and we will help you out ;-) -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Aline" wrote: I"d like to use a vlookup function,that is part of macro, will return certain values to the next column. Example, only Green and Red value is copied on the column B from column A. column A Column B Green Green Brown Brown Green Green Red Red Red Red Black Red Red Wonder if anyone could help me. Thanks, Aline -- Aline |
All times are GMT +1. The time now is 02:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com