I have an excel spreadsheet with columns A - Z with headers. I want to create a formula to look in a specific column/cell for a specific word, if found, then I want another column/cell to populate a #.
This is the formula I am using: =IF(ISNUMBER(SEARCH("USED VEHICLE-FIXED RATE",N2:N1000000)),"37","")
I get the results I need but I can't figure out a formula to cut and paste the number into the correct column/cell.
2018-02-23_16-40-04.jpg
Bookmarks