Monday, December 31, 2012 5:09 AM
I was trying to enter a column value based on an expression.
I want to search a column which has a certain text(using wild card) and vlookup with a different column if the value matches insert in the column value from second column.
I have to find Linux and enter it in a column .
Sheet 1 Col1 has Linux,IBM,Oracle
Sheet 2 COl2 has Linux
SHeet 3 Col4 must be LInux based on Vlookup.
IF (Sheet 1 Col1)matches (Sheet 2 COl2) then SHeet 3 Col4=Sheet 2 COl2
Monday, December 31, 2012 3:39 PM
This sounds like a purely Excel question. If I'm reading this correctly, I'd suggest posting in the MSDN Excel forum or on MrExcel.
For a native Excel solution, assuming you are comparing corresponding rows in the defined columns, you can use the SEARCH and FIND functions in Excel to search a string for the existence of another string and return the starting position of a match. Then, if that starting position is a valid value, return your lookup value in the target. Something like:
Hope that helps.
Brent Greenwood, MS, MCITP, CBIP
// Please mark correct answers and helpful posts //
Monday, December 31, 2012 4:59 PMDoes this work for wildcard search,I mean A2 has multiple values seperated by comma.
Monday, December 31, 2012 7:22 PM
Yes. Give it a try. More examples and details here.
Brent Greenwood, MS, MCITP, CBIP // Please mark correct answers and helpful posts // http://brentgreenwood.blogspot.com