I am wanting to have a column analyzed and if the number in the column cell is 1 or greater then paste in another workbook column yes or no. Do I use vlookup for this? Or is there some other excel magic that I am supposed to use? What I am wanting to do is if the cell contains 0 example1 workbook then in the example workbook2 paste the word no not available or yes available. Attached are sample workbooks
Bookmarks