PDA

View Full Version : searching data if id of column matches



sarat
06-24-2013, 10:52 AM
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
06-24-2013, 01:50 PM
What is CLOB sata?

What data do you want displayed?

Pleas answer using sheet and columns letters.

sarat
06-24-2013, 09:57 PM
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
06-25-2013, 07:21 AM
This formula will work.
=VLOOKUP(B6,UPDATE!A:B,2,FALSE)

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