Jump to content



Photo

Check number against list in Excel


  • Please log in to reply
3 replies to this topic

#1 Nashy

Nashy

    Neowinian Senior

  • Joined: 05-September 04
  • Location: Brisbane, Australia
  • OS: Windows 8.1
  • Phone: Samsung Galaxy S5 - SM-G900i

Posted 17 June 2008 - 01:12

Alright. Here's what I need to do:

Type a number in a cell, and it checks against a list in another sheet, and displays in another Cell YES or NO.

What's the formula for this?


#2 vetdreamz

dreamz

    discreet artist

  • Joined: 19-March 03

Posted 17 June 2008 - 01:41

you can use the 'match' function (for match type, you can use '0') or vlookup (for column index, put '1', since your list has only one column). now, if the lookup value isn't contained in the list, you'll get a '#N/A' error. put all this together with an if-statement: =IF(ISERROR(MATCH(A1,LIST,0)),"NO","YES").

#3 OP Nashy

Nashy

    Neowinian Senior

  • Joined: 05-September 04
  • Location: Brisbane, Australia
  • OS: Windows 8.1
  • Phone: Samsung Galaxy S5 - SM-G900i

Posted 17 June 2008 - 01:46

Thanks! That's perfect!!

#4 vetdreamz

dreamz

    discreet artist

  • Joined: 19-March 03

Posted 17 June 2008 - 14:14

glad i could help. :)