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
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Has Value (this is where the formula goes)[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Has Value[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Has Value[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]No Value[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]No Value[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Has Value[/TD]
[/TR]
</tbody>[/TABLE]


In sheet2
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Revenue[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]$100[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]$200[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]$200[/TD]
[/TR]
</tbody>[/TABLE]

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