FIND VALUE IN COLUMN

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i can't figure the logic to this statement

IF A2 EXISTS IN K2:K155 THEN "80100" ELSE FALSE

how would i write that in excel?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked Cells – If Statement 1
Find Max in array- return corresponding cell 2
If then else 2
IF conditional to copy column from one spreadsheet to another 3
Need Formula to "Adjust" to New Column Assignment 3
Conditional formatting using If 1
retain value and delete format 6
If a Row is blank 13

Back
Top