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
797
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!