I'm looking for a formula, or any other way, that will search one column for a value and if it finds it, will display the value from the same row but next column.
For example <https://lh6.googleusercontent.com/-QQagEPcwjx0/U2Axm-PKRkI/AAAAAAAAAAM/JHJEixcfrW0/s1600/Capture.JPG> So whatever the user types into D4, it will search if it is in column A and return the value next to it in column B and put it in E4 I know a couple ways of doing this such as / =IF(ISNUMBER(SEARCH("RED",D4)),"COLOR" / but there will be nearly 200 values and the list is constantly updating on a separate sheet. Thank you -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
