Hi, I'm looking for a formula (I assume it will be of the vlookup variety) that will determine if a lookup value appears in an array in a different sheet on the file.
If the value does appear, then "true" should be displayed in the cell. If not, then "false" should be shown.
To clarify, there is a sheet with a list of quotes, and a job sheet. When a quote gets converted to a job, and entered on the relevant sheet, I would like the a 'status' column to display that the job has been converted. The formula will be entered in the status column ('Quotations Sheet' Col H), the lookup value in the quote reference column ('Quotations Sheet' Col A) and the array is on 'Job Sheet'!B3:B387.
Any help would be much appreciated
Bookmarks