#1
|
|||
|
|||
Help with Excel Formula
Hi,
I have been referred to this forum from techsupportforum, so hopefully somebody will be able to help me. In the attached Excel file I have 2 sheets. In sheet "CPU Database", I want to add a formula in cell J2 as follows:- IF the value in A2 is replicated in sheet "W11 Supported (Intel Core)"/Range A2:A256 Then return a value = "Yes" If NOT, return a value of "No" Tommy |
#2
|
|||
|
|||
Code:
=IFERROR(IF(VLOOKUP($A2,'W11 Supported (Intel Core)'!$A$2:$A$256,1,0)>"","Yes","No"),"No") |
#3
|
||||
|
||||
Arvi, I think there is a flaw in your answer.
The text returned by the VLOOKUP will ALWAYS be larger than the null text string. The formula seems to return "yes" always Perhaps Code:
=IF(countif('CPU Database'!$A$2:$A$44,$a2),"yes","no") |
#4
|
|||
|
|||
Quote:
No #N/A #N/A No #N/A #N/A No #N/A #N/A No #N/A #N/A No #N/A #N/A No #N/A #N/A No #N/A #N/A No #N/A #N/A No #N/A #N/A No #N/A #N/A No #N/A #N/A No #N/A #N/A No #N/A #N/A Yes i3-9300 Yes Yes i3-9320 Yes Yes i3-9350K Yes No #N/A #N/A No #N/A #N/A No #N/A #N/A No #N/A #N/A No #N/A #N/A No #N/A #N/A No #N/A #N/A 1st column is returned by actual formula; 2nd column is returned by VLookup(); 3rd column is returned by If(). With 4th parameter 0/False, VLOOKUP returns #N/A always, when no exact match was found! |
#5
|
|||
|
|||
Thanks for the support ArviLaanemets.
That worked perfectly |
#6
|
||||
|
||||
Quote:
|
#7
|
|||
|
|||
Because the formula is on wrong sheet! You are checking, do Model's displayed on sheet 'W11 Supported (Intel Core)' exist on sheet 'W11 Supported (Intel Core)'!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Formula - Help | guiverdi | Excel | 2 | 07-23-2017 11:48 PM |
excel if formula | LPerry | Excel | 2 | 03-06-2017 07:14 AM |
excel formula | jcaal50 | Excel | 6 | 05-16-2014 04:01 PM |
excel help Formula | sellspeed | Excel | 15 | 03-10-2010 10:57 AM |
Excel Formula Help | Shahzad | Excel | 1 | 12-07-2008 04:13 AM |