create a search and display worksheet

**andy jam3s** · 05-21-2011, 10:42 AM

Hi, a bit tricky to explain so please bear with me,
I have a master worksheet with 4000 rows and 20 columns
I have created another worksheet in the same workbook to display data from the first worksheet in a different manner it is required by the client to be displayed in the new format.
however the data must be displayed as a search i.e. if i put in a value in D10 on sheet 2 that needs to then display data from row 10 on sheet1 in various boxes across the page on sheet 2.

please help, i think there must be a dead easy method for this i am overlooking

**abousetta** · 05-21-2011, 01:04 PM

Hi and welcome to the forum,

Easiest way I can think of is to use a VLookup formula. Attached is a simple example and you can modify the formula to catch possible problems like the user puts a reference ID that is not in the database, etc.

Good luck.

abousetta

**Marcol** · 05-21-2011, 01:14 PM

@ abousetta
IFERROR() is not available to 2003 it was introduced in 2007.

andy jam3s is using 2003 according to his profile

**abousetta** · 05-21-2011, 01:36 PM

Thanks Marcol... I really need that morning coffee

That's my mistake. I didn't even notice that. Let me amend and repost.

abousetta

**abousetta** · 05-21-2011, 01:42 PM

Attempt #2.. replaced IFERROR with ISBLANK (also could use ISERROR instead of ISBLANK).

abousetta

**andy jam3s** · 05-23-2011, 01:48 PM

hey thanks guys, transposed formula and it works a treat, just trying to understand the code, i get the vlookup part and the column number bit its just the last few bits to do with the "" marks and the 0. I am not sure how to mark as solved thanks again everyone it has saved me a months work at least

**abousetta** · 05-23-2011, 06:19 PM

Hi,

Glad we could be of assistance. If you are satisfied with the results, please mark the thread as [SOLVED] (next to the title on the first post). Also positive recognition (scales) are always welcomed .

If want to mark the post as solved then:

1) Click the Edit button on your first post in the thread
2) Click Go Advanced
3) select [SOLVED] from the Prefix dropdown
4) click Save Changes

I wasn't sure from your post if you wanted further explanation of the forumlas or not. If so, please post back.

Good luck.

abousetta