Formula Query

P

Pmcl

Hi all,
Not sure if this is possible but I have a range of data in column B1:B200
and a range of text in column A1:A200. I want to set a formula so that if
the data in any of the cells in column B equals a particular value then the
text from the relevant cell in column A is output
 

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

how to make a formula work for the whole column 6
How to put a formula in a column 6
countifs Function not giving desired result with date criteria 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Copying concatenate not returning correct cell information 6
Excel VBA 1
autofill colour based on date entry 8
if(isna(match formula 8

Top