Lookuk a value in 2 columns and get value of third (help)

Solved/Closed
sharifa6869 Posts 3 Registration date Monday August 11, 2014 Status Member Last seen August 13, 2014 - Aug 11, 2014 at 03:51 AM
sharifa6869 Posts 3 Registration date Monday August 11, 2014 Status Member Last seen August 13, 2014 - Aug 12, 2014 at 02:55 AM
Hello,

I have a question

I need to lookup a value of col A1 of sheet 1 in col A of sheet 2 and if it matches it gets the corresponding value of col B of sheet 2

for example

sheet 1

col A |------------| col B

BA0001|--------|=formula
BA0002
BA0003
BA0004
BA0005

-------

sheet2

col A ----------- col B

BA0123 |--------| BOBSC3
BA0124 |--------| BOBSC2
BA0139 |--------| BOBSC4
BA0001 |--------| BOBSC56
BA0223 |--------| BOBSCh6


please help

thank you


1 reply

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Aug 11, 2014 at 08:03 AM
sharifa6869, Good morning.

Try to use:
Sheet1 =formula -->
=VLOOKUP( A1 , SHEET2!A1:B10 , 2 , FALSE )

Adapt it to your reality as necessary.

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
sharifa6869 Posts 3 Registration date Monday August 11, 2014 Status Member Last seen August 13, 2014
Aug 12, 2014 at 02:55 AM
yesssss!!

thank you that worked !!
0