Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i check if something non numeric is in a range & return'Y'
I've got a massive list of phones, some of which are colour and some are not eg
s60X 8810 530g 7210 6210 I have another list which tells me which phones are colour Phone Colour 7210 Y 6210 Y g43 y How do i find out without doing it manually which phones in my first list are colour AM gutted that i can't work this out |
#2
|
|||
|
|||
amung the ways would be conditional formatting
select the first data set <format<Conditional Format Formula is Upper(vlookup(Current cell,second range,2,false))="Y" set the format as you want. note I often have to go backinto conditonal format to get rid of unwanted quote marks and verify relative absolute cell referencing is correct. "Becs" wrote: I've got a massive list of phones, some of which are colour and some are not eg s60X 8810 530g 7210 6210 I have another list which tells me which phones are colour Phone Colour 7210 Y 6210 Y g43 y How do i find out without doing it manually which phones in my first list are colour AM gutted that i can't work this out |
#3
|
|||
|
|||
Assume your first list is in column A and your second in columns J and K
in B1 put this formula and copy down........ =IF(ISNA(VLOOKUP(A1,J:K,2,FALSE)),"",VLOOKUP(A1,J: K,2,FALSE)) Vaya con Dios, Chuck, CABGx3 "Becs" wrote in message ... I've got a massive list of phones, some of which are colour and some are not eg s60X 8810 530g 7210 6210 I have another list which tells me which phones are colour Phone Colour 7210 Y 6210 Y g43 y How do i find out without doing it manually which phones in my first list are colour AM gutted that i can't work this out |
#4
|
|||
|
|||
That, my friend, was the ********!!
Thank you so much B "CLR" wrote: Assume your first list is in column A and your second in columns J and K in B1 put this formula and copy down........ =IF(ISNA(VLOOKUP(A1,J:K,2,FALSE)),"",VLOOKUP(A1,J: K,2,FALSE)) Vaya con Dios, Chuck, CABGx3 "Becs" wrote in message ... I've got a massive list of phones, some of which are colour and some are not eg s60X 8810 530g 7210 6210 I have another list which tells me which phones are colour Phone Colour 7210 Y 6210 Y g43 y How do i find out without doing it manually which phones in my first list are colour AM gutted that i can't work this out |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
function to check numeric value | Excel Worksheet Functions | |||
Database text converted to numeric | Excel Discussion (Misc queries) | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
Auto spell check as in word | Excel Discussion (Misc queries) | |||
Creating a check box that does not require security clearance. | Excel Worksheet Functions |