Lookup or find in excel help [Solved/Closed]

Question

Lookup or find in excel help [Solved/Closed]

Report

Paul - Dec 13, 2010 at 07:35 PM
Paul - Dec 14, 2010 at 06:58 AM

Hello,

I have 2 data sheets sheet one contains my Master list of items by number
Row 1 Column 1: 453658
Row 2 Column 1: 839565
Etc
my second sheet has the information I want to get to:

Row 1 Column 1: Gloves 453658A Black , Row 1 Column 2, $4.99
Row 2 Column 1: hat 839565 Pink , Row 2 Column 2, $8.99
etc

I want to search for 453658 and it returns me the $4.99 ignoring the rest of the information in that box so I end up with
453658 $4.99

The closest I have got is using a lookup formula but this only works if the data in both column 1's are exactly the same.

=VLOOKUP(A1,Sheet2!$A$1:$B$50000,2,FALSE)

Please Help

Paul

Lookup or find in excel help
Excel - macro to lookup cell and add new row - How-To - Excel
Complicated Lookup in Excel - How-To - Excel
Ms excel, lookup word from a cell ✓ - Forum - Excel
Complicated Lookup in Excel ✓ - Forum - Excel
Values Lookup in excel ✓ - Forum - Excel

2 replies

Answer 2 / 2

Paul
Dec 14, 2010 at 06:58 AM

Thanks that has worked perfectly !!!

Paul

Ask a question

venkat1926 · Accepted Answer · 2010-12-14T05:06:59-0500

Answer 1 / 2

venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

797
Dec 14, 2010 at 05:06 AM

in the first sheet (master sheet) in row 1 column 2 (that is cell B1) copy this formula

=VLOOKUP("*"&A1&"*",Sheet2!$A$1:$B$100,2,0)

you can copy B1 down

I assume there are less than 100 rows.

Lookup or find in excel help [Solved/Closed]

2 replies

Your reply

Subscribe To Our Newsletter!