IF function multiple criteria

hi guys,

statement basically needs to say if cell a1 = "certain phrase" AND B1 is populated then return value in B1.

can't seem to get my IFs and ANDs right :/

can anyone help please?

What about the else? What if B1 is not populated, what do you want as the answer?

"" - this would leave it blank yes?

Your formula should be
=IF(AND(A1="certain phrase",B1<>""),B1,"")

thank you very much for your swift help! can i adapt this for column refs instead of cell references?

You are welcome. I dont think so. But you can drag the formula down to how many ever rows you need and it will take the respective row references.

hmmm, may not have asked for what i needed then!!

i've uploaded a scaled down version of what i'm working on.

i want my formula to say if column A on sheet 2 matches column A on sheet 1 AND column K on sheet 2 is populated, then return value of column K. Sorry to be a nuisance, thought i'd try and simplify things and have ended up complicating them!!

can anyone help?

We can use a simple vlookup formula. But my understanding is that in column A of sheet 2 a data value from Column A 1 may come more than 1 time. Example. "AUDIO" may have 2 orders and may come in row 5 and row 9. If the Column A data comes only once then we can use vlookup. Is there anything else that we need to match.
vlookup formula

Please Login or Register  to view this content.

hmm, formula is returning #NAME? error? thanks for your persistence with this, i think understand how the vlookup is working and yes, i think it will give me what i need without matching anything else.

EDIT: sorry, yes, data will be repeated in column a of sheet 2, but will not be repeated in column a of sheet 1

Please Login or Register  to view this content.

I've used the above and i think it works, it's returning N/A for when column K isn't populated which is a bit annoying but maybe i can live with it...

it is not giving me any error. Attached is the sheet.

However I was wondering what is the use of the sheet. You said that the data may be repeated in Sheet 2. So vlookup will only give you the first instance of that data in the sheet. What about the second instance. I have highlighted what I am trying to say in the attached sheet

Thanks for all of your help inayat, that's sorted it!