searching data if id of column matches

[sarat]

Hi,
In my sheet 'Data', one column 'case_num' with respective ID are there.

The CLOB data of each case_num are available in another sheet 'Update'.

My requirement.

when I select any of the case_num from sheet 'data' and if their matching record is available in sheet 'update', then that data will displayed.

What formual should be used.

[SamT]

What is CLOB sata?

What data do you want displayed?

Pleas answer using sheet and columns letters.

[sarat]

CLOB data in the sense description of few ID from case_num (in sheet data) are available in update sheet.

e.g. case_num from sheet data (PHFR2012GB006089 )--- available in narrative column of sheet update if it match with the same id
(Case number PHFR2012GB006089 is a spontaneous initial report received from a RAVI (available in narrative column)

my requirement without going to sheet update, how can I display the output data of individual case number in sheet 'data'.

[SamT]

This formula will work.
[VBA]=VLOOKUP(B6,UPDATE!A:B,2,FALSE)[/VBA]

This Formula works like above, but will not tell you there is no match
[VBA]=IF(ISERROR(VLOOKUP(B6,UPDATE!A:B,2,FALSE)),"",VLOOKUP(B6,UPDATE!A:B,2,FALS E))[/VBA]
Change "B6" to Column letter and Row number of Case_Num Cell