search formula

how do I make a VBA to search a few times with different highlight color? For example, the first time I search is "AS", then all results with "AS" will be highlighted in yellow. Then the second time, I search is "BD", then all results with "BD" will be highlighted in green. Then the 3rd, I...

Hi All, I am using the following formula in Excel Subscription product 365 to return a text value in the adjacent cell: =IF(B11="","", IF(SEARCH("FNQ",B11),"FNQ", IF(SEARCH("NQ",B11),"NQ", IF(SEARCH("FWQ",B11),"FWQ", IF(SEARCH("CQ",B11),"CQ", IF(SEARCH("WBB",B11),"WBB"...

Hello! Here is the logic behind the formula I am searching for. I have a cell where I enter values A1, say 1 through 10. I have a master list of numbers 1 through 10, just for reference in the formula. Say B1:B10. Lets say I enter the number 7 in A1. I want another cell to then search a...

hi guys! how do i write this in VB =MID(A1,SEARCH(" ",A1,1)+1,SEARCH(" ",A1,SEARCH(" ",A1,1)+1)-SEARCH(" ",A1,1)) i want to have this formula inside my already created function SKU in VB, I really dont know any VB. Function SKU(myEntry As String) As String SKU = Left(myEntry, 3) &...

Dear All , I want a formula where in Sheet1 col .A1 "SINGH PAWAN MR" But in Sheet2 col.A1 = PAWAN KUMAR in B1= 9500 what i want is if i can search Sheet 1 A1= "SINGH PAWAN MR" = 9500 by any formula. please help if any formula can find this it will be very help full for me . Thanks in advance