Look up a value in a list and return multiple corresponding values

**Jord-** · 10-18-2011, 06:00 AM

Heyy, i have been searching for like AGESSSS! and cannot find anything to help me with this matter.... i will explain my problem...

Colum A has part numbers (0001 and so on and so on) * they are not decending in 1's they are random numbers so to speak...

on the next sheet there is colum A (wich contains part numbers *the main part numbers*)
and colum B has the item description, colum c has the sale price and colum d has the cost price...

I basicly am looking so that on the 1st sheet i can enter a formula witch will match up the part numbers from sheet 1 to sheet 2 and will return the description / cost / sale ...

Make sence???

Sheet 1 looks like this:

0001
0010
0023
0123
2034
9821

Sheet too looks like this
A B C D
0001 description in this colum sale price here cost price here
0002 description in this colum sale price here cost price here
0003 description in this colum sale price here cost price here
0004 description in this colum sale price here cost price here
.. ect ect

**arthurbr** · 10-18-2011, 06:42 AM

Hi and welcome to the board

Have a look at the VLOOKUP function

Cheers

**Jord-** · 10-18-2011, 07:57 AM

Originally Posted by arthurbr

Hi and welcome to the board

Have a look at the VLOOKUP function

Cheers

Heyy, i have looked at allsorts and i cannot figure it out, ive searched all over googled ect ect, playing with peoples different awnswers ect ect

**arthurbr** · 10-18-2011, 10:10 AM

Please add a sample sheet - Thx

**Jord-** · 10-18-2011, 10:36 AM

Example workbook attached.. Thanks

**khamilton** · 10-18-2011, 10:44 AM

Note this only finds the first match. For instance you have 00010 3 times in the first sheet.

SAMPLE.xlsx

**Jord-** · 10-18-2011, 10:59 AM

Originally Posted by khamilton

Note this only finds the first match. For instance you have 00010 3 times in the first sheet.

Attachment 125262

Wow thanks :D:D:D... only problem is i get this at the end ...

30281 #N/A #N/A
39999 #N/A #N/A
40010 #N/A #N/A
40020 #N/A #N/A
40025 #N/A #N/A
40045 #N/A #N/A
40050 #N/A #N/A
40452 #N/A #N/A
40462 #N/A #N/A
50085 #N/A #N/A
50090 #N/A #N/A
50150 #N/A #N/A
50155 #N/A #N/A
50280 #N/A #N/A
50320 #N/A #N/A
50535 #N/A #N/A
50552 #N/A #N/A
70196 #N/A #N/A
70198 #N/A #N/A
70202 #N/A #N/A
70205 #N/A #N/A
70208 #N/A #N/A
70211 #N/A #N/A
70215 #N/A #N/A
70228 #N/A #N/A
70290 #N/A #N/A

**khamilton** · 10-18-2011, 03:41 PM

Okay here it is with the error handler.

SAMPLE.xlsx

**Jord-** · 10-19-2011, 03:05 AM

Originally Posted by khamilton

Okay here it is with the error handler.

Attachment 125319

I mean how come it comes up with error? the data is the same as all the other cells, i dont understand :S:S

**khamilton** · 10-19-2011, 09:04 AM

Looks like they are some with spaces at the end of some. Sheet 1 column A.

Look up a value in a list and return multiple corresponding values

LinkBack

Thread Tools

Rate This Thread

Display

Look up a value in a list and return multiple corresponding values

Re: How to look up a value in a list and return multiple corresponding values.

Re: How to look up a value in a list and return multiple corresponding values.

Re: How to look up a value in a list and return multiple corresponding values.

Re: How to look up a value in a list and return multiple corresponding values.

Re: How to look up a value in a list and return multiple corresponding values.

Re: How to look up a value in a list and return multiple corresponding values.

Re: How to look up a value in a list and return multiple corresponding values.

Re: How to look up a value in a list and return multiple corresponding values.

Re: Look up a value in a list and return multiple corresponding values

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions