If Statement possibly?
Hi I hope you can help me out he -
Col A (SCHEME NAME) Col B (AGENT) DRIVESURE AMERICASURE INTERGROUP EXTRASURE WORLDWIDE TRAVEL AVIS What i want to do: - If in another worksheet I type in DRIVESURE in ie A1 I would like AMERICASURE to appear in ie B1. In other words depending on what Scheme Name I type in I would like the corresponding Agent to appear in the next column. If I were to type in a Scheme name that didnt exist then False should show. I am not sure what formula I should use here. ***************************************** * This message was posted via http://www.officekb.com * * Report spam or abuse by clicking the following URL: * http://www.officekb.com/Uwe/Abuse.as...0a43fbfc00020b ***************************************** |
Hi
Something like =VLOOKUP(A1,Sheet1!$A$2:$B$100,2,0) -- Arvi Laanemets (When sending e-mail, use address arvil<Attarkon.ee) "Matt Brown via OfficeKB.com" wrote in message ... Hi I hope you can help me out he - Col A (SCHEME NAME) Col B (AGENT) DRIVESURE AMERICASURE INTERGROUP EXTRASURE WORLDWIDE TRAVEL AVIS What i want to do: - If in another worksheet I type in DRIVESURE in ie A1 I would like AMERICASURE to appear in ie B1. In other words depending on what Scheme Name I type in I would like the corresponding Agent to appear in the next column. If I were to type in a Scheme name that didnt exist then False should show. I am not sure what formula I should use here. ***************************************** * This message was posted via http://www.officekb.com * * Report spam or abuse by clicking the following URL: * http://www.officekb.com/Uwe/Abuse.as...0a43fbfc00020b ***************************************** |
All times are GMT +1. The time now is 10:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com