Lookup Column and then Compare whther data is found in Column

[Cai123]

Hi Guys,

Appreciate some help over here.

I have 2 worksheets namely DataBase and Workings.

In Data Base, i have the first row as my header and some dates. Example as below

Column A :

USD

01-Jan-13</SPAN>

21-Jan-13</SPAN>

18-Feb-13</SPAN>

<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>

Column B :

CNY
01 Jan 2013
02 Jan 2013

In Workings, Column A has USD and Column B has some dates . Example, USD 01 Jan 2013.

What i am trying to do here is trying to is, in workings sheet, i am looking to Lookup data in "Database" with the header first, before going through the entire column to see whether the dates in Column (B) - in "Working"sheet is found.

Any ideas how to do it ? Been searching the entire day before posting this. Hope someone can help me here.

​

<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>

 

[iambharat]

why do you want to look up the header field first ?

 

[rjwebgraphix]

What do you mean by, "i am looking to Lookup data in "Database" with the header first"

Not exactly sure what you're trying to do.

 

[Athena55]

It sounds like you may just need the vlookup formula to compare two vertical lists. Not sure what you mean by header first.

 

[Cai123]

Hi Guys,

Thanks for replying.

What i mean by ""i am looking to Lookup data in "Database" with the header first"

is that "Database" is my refrence table to lookup against to. They will have the title like USD, CNY and many more.

In "Working" sheet, there will be a KEY reference in Column A like CNY,USD and many others. Column B will have different dates.

So what i am trying to do is in Worksheet Sheet, i want to do a lookup against Database with the KEY reference against the reference table in "Database" and using the "Database" respective dates on it , to check whether they are of the same value.

Hope you can what i mean here. Again, thanks for your help.

 

[Aladin Akyurek]

Hi Guys,

Appreciate some help over here.

I have 2 worksheets namely DataBase and Workings.

In Data Base, i have the first row as my header and some dates. Example as below

Column A :

USD

01-Jan-13

21-Jan-13

18-Feb-13

<tbody>
</tbody>

Column B :

CNY
01 Jan 2013
02 Jan 2013

In Workings, Column A has USD and Column B has some dates . Example, USD 01 Jan 2013.

What i am trying to do here is trying to is, in workings sheet, i am looking to Lookup data in "Database" with the header first, before going through the entire column to see whether the dates in Column (B) - in "Working"sheet is found.

Any ideas how to do it ? Been searching the entire day before posting this. Hope someone can help me here.

<tbody>
</tbody>

Looks like...

Workings, C2, just enter, and copy down:

=ISNUMBER(MATCH(B2,INDEX(DataBase!$A$2:$Z$600,0,MATCH(A2,DataBase!$A$1:$Z$1,0)),0))+0

A result of 1 means a hit, otherwise a miss.

 

[Cai123]

Excellent , works perfect !

 

[Aladin Akyurek]

Excellent , works perfect !

You are welcome.

 

[Cai123]

Excellent , works perfect !