ExcelBanter - vlookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - vlookup (https://www.excelbanter.com/excel-worksheet-functions/243076-vlookup.html)

ideasailer

vlookup

I have two wok book. in one there are a lot of nos like
book no1
321127
92117-0002
in other book2
321127-00
0092117-02
how can we use vlook up

Jacob Skaria

vlookup

If book2 is array Sheet2!A1:A100 try the below formula ..
Lookup value in cell A1 is from book no 1 .

=VLOOKUP("*" & LEFT(A1 & "-",FIND("-",A1)-1) & "*",Sheet2!A1:A100,1,0)

If this post helps click Yes
---------------
Jacob Skaria

"ideasailer" wrote:

I have two wok book. in one there are a lot of nos like
book no1
321127
92117-0002
in other book2
321127-00
0092117-02
how can we use vlook up

Mike H

vlookup

Hi,

You can use a wildcard

=VLOOKUP("*"&A2&"*",[Book2]Sheet1!$A$1:$B$20,2,FALSE)

so if A2 contains 321127
it will find 321127-00 in book 2.

Mike

"ideasailer" wrote:

I have two wok book. in one there are a lot of nos like
book no1
321127
92117-0002
in other book2
321127-00
0092117-02
how can we use vlook up

All times are GMT +1. The time now is 01:15 AM.