Lookup or find in excel help [Solved/Closed]

Report
-
 Paul -
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

2 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
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.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Thanks that has worked perfectly !!!

Paul