Cell = a value based on matching cell values AND another cell not being blank

[dbarbella]

Hey Gang,
Wasn't sure how to properly word the subject, but let me share the unique scenario.

Matching the Unique ID's, I need to check if sheet2 has a value listed.
If so, then sheet1 just says "Has Value", otherwise it says "No Value"

So in a way, I'm hiding the dollar amounts and replacing it with an explanation

There's a fairly long list, so I need to copy and paste the formula throughout column B of sheet 1. Where it grabs the ID number in column A -> finds the matching ID number in column A of Sheet2 -> checks if column B of sheet2 (only of the same row as the matching ID) is blank -> then but the replacement value into column b


In sheet1

ID	Has Value (this is where the formula goes)
1	Has Value
2	Has Value
3	No Value
4	No Value
5	Has Value

<tbody>
</tbody>

In sheet2

ID	Revenue
1	$100
2	$200
3
4
5	$200

<tbody>
</tbody>

Hope that makes sense.
This is part of an actually much larger document with many other columns. I just used a simple 2 column example to help explain (If Pivot table is a common approach, I don't know that it will work in the larger scheme of the spreadsheet).

Thanks much
-Dave

 

[ad1234]

You need to use a VLOOKUP from sheet one in conjunction with an IF e.g. =IF(VLOOKUP(A2,sheet2range,2,0)="","No Value","Has Value"))

 

[dbarbella]

Thanks so much, I'll give that a go