Shaikh Aziz
New Member
- Joined
- Dec 18, 2020
- Messages
- 35
- Office Version
- 2007
- Platform
- Windows
Dear All,
Please help me out or suggest me how to vlookup with cell backgrond color, eg. i have sheet1 & 1000 names in column A and i want to vlookup columnB values with multiple cell colors (with formatting) in sheet2 ColumnB according to columnA. please suggest me any shortcut or vlookup formula for V-looking up with cell background colors.
NOTE: I have matched names in Sheet1 & Sheet2 in ColumnA. and we want to vlookup along with cell background color from one sheet to another sheet.
Also PFB cross posting link for reference, i am still haven't found an answer, please help me.
Thankyou All.
Please help me out or suggest me how to vlookup with cell backgrond color, eg. i have sheet1 & 1000 names in column A and i want to vlookup columnB values with multiple cell colors (with formatting) in sheet2 ColumnB according to columnA. please suggest me any shortcut or vlookup formula for V-looking up with cell background colors.
NOTE: I have matched names in Sheet1 & Sheet2 in ColumnA. and we want to vlookup along with cell background color from one sheet to another sheet.
Also PFB cross posting link for reference, i am still haven't found an answer, please help me.
Vlookup with cell background color
Dear All, Please help me out or suggest me how to vlookup with cell backgrond color, eg. i have sheet1 & 1000 names in column A and i want to vlookup columnB values with multiple cell colors (with formatting) in sheet2 ColumnB according to columnA. please suggest me any shortcut or vlookup...
www.excelforum.com
Thankyou All.
