Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet function?
Hello,
I would like to write a worksheet function which compare the contents in two cell from a database1 with the contents in two columne in database2. Whenever there is a match I would like it to return a a prespecified text (i.e Yes or No)and a value from database2 associated with the found match in cells of database1. Empty cells in database1 (in one or both the cells where comparasions values are found) also needs to be considered as no comparasion should be made (i.e. do not return the text Yes/No for the first match with any empty cell in database2). Anyone that has suggestions? Kind regards Jonas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet function?
This looks like a Vlookup function but with two lookup cells. A way to do
that is to concatenate the pairs of cells in a new column and use that in your lookup, i.e. if the first cells in database1 are in A2 and B2, insert a column at C and type in it the formula =A2&B2 and copy it all the way down. Do the same in datbase2 and then you can use an ordinary Vlookup because you've now only got one cell to compare. "Jonas" wrote: Hello, I would like to write a worksheet function which compare the contents in two cell from a database1 with the contents in two columne in database2. Whenever there is a match I would like it to return a a prespecified text (i.e Yes or No)and a value from database2 associated with the found match in cells of database1. Empty cells in database1 (in one or both the cells where comparasions values are found) also needs to be considered as no comparasion should be made (i.e. do not return the text Yes/No for the first match with any empty cell in database2). Anyone that has suggestions? Kind regards Jonas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
example using DSUM worksheet function in a VBA function | Excel Programming | |||
Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
Can the offset worksheet function reference another worksheet | Excel Worksheet Functions | |||
formula/function to copy from worksheet to worksheet | Excel Programming | |||
worksheet function? | Excel Programming |