Lookups, etc.

[PatriciaM]

I have 2 spreadsheets. Spreadsheet #1 contains my data in it's raw form. I wish to create another Spreadsheet for my data to show in it's final form. In this new Spreadsheet #2 I have one cell into which I will enter data. This data matches data in column 1 of Spreadsheet #2. I wish to bring over the data into Spreadsheet #2 that matches what I have keyed in. I know about vlookup. However, I don't wish for Spreadsheet #2 to show lines for those items that do not match. Example: There are 200 records in Spreadsheet #1 and I only want those 10 records that matched what I keyed in to show up on Spreadsheet #2. Any suggestions?

 

[immyjimmy]

Welcome to the board!

I use the following in one of my books. I have a column with this formula.

=IF(C2="","",IF(ISNA(VLOOKUP(C2,'Part Code.xls'!PART_CODE,(3),0)),"Item Not Found",VLOOKUP(C2,'Part Code.xls'!PART_CODE,(3),0)))

If the lookup cell is blank, my result is blank. If there is no match, the cell tells me no match is found. If the lookup cell matches, only then do I get a return value.

HTH,
Jim

 

[PatriciaM]

Lookup, etc.

I only wish to see rows for those items that match specific data. I don't want rows that doen't match.

 

[immyjimmy]

Can you post an example of what you have and what you want? I (or some one else) might have a better idea of what you need...

Jim