display part 2
What if the numbers were followed by letters?
"Dave Peterson" wrote:
If the numbers you have in sheet2 column A always end with 00000, you could use:
=VLOOKUP(A1*100000,Sheet2!A:B,2,FALSE)
GAIDEN wrote:
SHEET 1 SHEET 2
A A B
2011 | 204200000 LOGO
2015 | 201500000 AGEN
2022 | 201100000 STAR
2032 | 205400000 DURA
2034 | 203200000 WRAP
2035 | 203500000 WORK
2042 | 202200000 GROU
2054 | 203400000 ALTI
I'm trying to display the values in column B (Sheet 2) next to the values in
column A (Sheet 1) by using the 1st 4 digits in column A (Sheet 2).
--
Dave Peterson
|