| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
prevent more than one value in a cell
Hi I am making a roster with the use of lookup (see below) - names say "andrew" and "am". I want only one name in either a1:a10 or a15:a20 either "andrew" or "am", but not both - is it a validation or vba or help andrew m =IF(ISNUMBER(MATCH("andrew",K15:K16,0)),VLOOKUP(MA TCH("andrew",K15:K16,0),J25:K29,2),IF(ISNUMBER(MAT CH("am",K19:K21,0)),VLOOKUP(MATCH("am",K19:K21,0), J25:L29,3),"")) -- andrewm ------------------------------------------------------------------------ andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130 View this thread: http://www.excelforum.com/showthread...hreadid=380377 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell addressing using the content of another cell. | Excel Worksheet Functions | |||
| How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
| How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
