Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Yes or blank, depending if value equals or exceeds value found inVLookup table.
Hi,
I am trying to have cell E2 display "Yes" if cell G2 is equal to or over a certain amount. This amount is determined by the text in cell C2. The text in cell C2 is tied to a Vlookup table on a sheet named "Index". For example, the text in cell C2 is "black", and the value in the column next to the word "black" on the Vlookup is 100. The value in cell G2 is 90, and since 100 is greater then 90, Cell E2 would display "yes". Conversely, the text in cell C2 is "brown", and the value in the column next to the word "brown" on the Vlookup is 80. The value in cell G2 is 90, and since 80 is less then 90, Cell E2 would be blank. Thanks for any help... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Yes or blank, depending if value equals or exceeds value found inVLookup table.
On Monday, January 7, 2013 6:36:40 PM UTC-8, Steve wrote:
Hi, I am trying to have cell E2 display "Yes" if cell G2 is equal to or over a certain amount. This amount is determined by the text in cell C2. The text in cell C2 is tied to a Vlookup table on a sheet named "Index". For example, the text in cell C2 is "black", and the value in the column next to the word "black" on the Vlookup is 100. The value in cell G2 is 90, and since 100 is greater then 90, Cell E2 would display "yes". Conversely, the text in cell C2 is "brown", and the value in the column next to the word "brown" on the Vlookup is 80. The value in cell G2 is 90, and since 80 is less then 90, Cell E2 would be blank. Thanks for any help... Hi Steve, Try this in E2 which will give you a "yes" for your "black" statement and by default a blank for the "brown" statement. =IF(AND(C2="black",D2G2),"yes","") Regards, Howard |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Yes or blank, depending if value equals or exceeds value found inVLookup table.
On Monday, January 7, 2013 6:36:40 PM UTC-8, Steve wrote:
Hi, I am trying to have cell E2 display "Yes" if cell G2 is equal to or over a certain amount. This amount is determined by the text in cell C2. The text in cell C2 is tied to a Vlookup table on a sheet named "Index". For example, the text in cell C2 is "black", and the value in the column next to the word "black" on the Vlookup is 100. The value in cell G2 is 90, and since 100 is greater then 90, Cell E2 would display "yes". Conversely, the text in cell C2 is "brown", and the value in the column next to the word "brown" on the Vlookup is 80. The value in cell G2 is 90, and since 80 is less then 90, Cell E2 would be blank. Thanks for any help... "Yes" if cell G2 is equal to or over a certain amount.<<<< Missed the EQUAL TO part... =IF(AND(C2="black",D2=G2),"yes","") Howard |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Yes or blank, depending if value equals or exceeds value found inVLookup table.
On Tuesday, January 8, 2013 1:53:15 AM UTC-5, wrote:
On Monday, January 7, 2013 6:36:40 PM UTC-8, Steve wrote: Hi, I am trying to have cell E2 display "Yes" if cell G2 is equal to or over a certain amount. This amount is determined by the text in cell C2. The text in cell C2 is tied to a Vlookup table on a sheet named "Index". For example, the text in cell C2 is "black", and the value in the column next to the word "black" on the Vlookup is 100. The value in cell G2 is 90, and since 100 is greater then 90, Cell E2 would display "yes". Conversely, the text in cell C2 is "brown", and the value in the column next to the word "brown" on the Vlookup is 80. The value in cell G2 is 90, and since 80 is less then 90, Cell E2 would be blank. Thanks for any help... "Yes" if cell G2 is equal to or over a certain amount.<<<< Missed the EQUAL TO part... =IF(AND(C2="black",D2=G2),"yes","") Howard Thanks Howard, however; this did not work. The Vlookup table on a sheet called "Index" contains the threshold value that "black" or "brown" has associated to it, and the formula you gave me doesn't reference this table. The absolute reference to this table is: VLOOKUP(C2,Index!$I$2:$J$100,2,0) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Yes or blank, depending if value equals or exceeds value found inVLookup table.
On Tuesday, January 8, 2013 5:09:51 PM UTC-5, Steve wrote:
On Tuesday, January 8, 2013 1:53:15 AM UTC-5, wrote: On Monday, January 7, 2013 6:36:40 PM UTC-8, Steve wrote: Hi, I am trying to have cell E2 display "Yes" if cell G2 is equal to or over a certain amount. This amount is determined by the text in cell C2. The text in cell C2 is tied to a Vlookup table on a sheet named "Index". For example, the text in cell C2 is "black", and the value in the column next to the word "black" on the Vlookup is 100. The value in cell G2 is 90, and since 100 is greater then 90, Cell E2 would display "yes". Conversely, the text in cell C2 is "brown", and the value in the column next to the word "brown" on the Vlookup is 80. The value in cell G2 is 90, and since 80 is less then 90, Cell E2 would be blank. Thanks for any help... "Yes" if cell G2 is equal to or over a certain amount.<<<< Missed the EQUAL TO part... =IF(AND(C2="black",D2=G2),"yes","") Howard Thanks Howard, however; this did not work. The Vlookup table on a sheet called "Index" contains the threshold value that "black" or "brown" has associated to it, and the formula you gave me doesn't reference this table. The absolute reference to this table is: VLOOKUP(C2,Index!$I$2:$J$100,2,0) I finally got back to messing around with this spreadsheet, and I figured it out. I am posting the solution that worked for me, just in case it could benefit someone else: =IF(ISERROR(G2(VLOOKUP(C2,Index!$I$2:$J$100,2,0)) ),"",IF(G2(VLOOKUP(C2,Index!$I$2:J$100,2,0)),"Y", "")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delete the non blank rows depending on Column | Excel Programming | |||
Finding the date in a table when one value first exceeds another. | Excel Worksheet Functions | |||
If cell is left blank, or equals zero, then cell equals a different cell | Excel Discussion (Misc queries) | |||
custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) | |||
how to write 'not equals blank' criteria in SUMIF | Excel Worksheet Functions |