Lookup and match reference in other WS

[BravoBravoAu]

Hi guys,


Hopefully an easy one – I often struggle withtroubleshooting the lookup function of excel.




I have a workbook with two worksheets:

1. Employee details (WS1)
   
2. Bank deposits (WS2)

Each month, I need to paste in bank deposit information intoWS2. I would like to be able to displaythe employee surname in WS2 based on the matching employee ID listed in thebank deposits (7-digit number) against the employee ID recorded in WS1.


WS1

<tbody> [TD="width: 208, bgcolor: transparent"] Employee ID [/TD]
[TD="width: 208, bgcolor: transparent"] Name [/TD]
[TD="width: 208, bgcolor: transparent"] 1234567 [/TD]
[TD="width: 208, bgcolor: transparent"] Brown [/TD]
[TD="width: 208, bgcolor: transparent"] 2345678 [/TD]
[TD="width: 208, bgcolor: transparent"] Arnold [/TD]
</tbody>

WS2

<tbody> [TD="width: 104, bgcolor: transparent"] Date [/TD]
[TD="width: 104, bgcolor: transparent"] Description [/TD]
[TD="width: 104, bgcolor: transparent"] Debit [/TD]
[TD="width: 104, bgcolor: transparent"] Credit [/TD]
[TD="width: 104, bgcolor: transparent"] Balance [/TD]
[TD="width: 104, bgcolor: transparent"] Employee lookup [/TD]
[TD="width: 104, bgcolor: transparent"] 15 Jul 18 [/TD]
[TD="width: 104, bgcolor: transparent"] 2345678 [/TD]
[TD="width: 104, bgcolor: transparent"] [/TD]
[TD="width: 104, bgcolor: transparent"] $1,236.00 [/TD]
[TD="width: 104, bgcolor: transparent"] $2,157.25 [/TD]
[TD="width: 104, bgcolor: transparent"] [/TD]
[TD="width: 104, bgcolor: transparent"] 13 Jul 18 [/TD]
[TD="width: 104, bgcolor: transparent"] 1234567 [/TD]
[TD="width: 104, bgcolor: transparent"] [/TD]
[TD="width: 104, bgcolor: transparent"] $523.00 [/TD]
[TD="width: 104, bgcolor: transparent"] $921.25 [/TD]
[TD="width: 104, bgcolor: transparent"] [/TD]
</tbody>

So in WS2, I am trying to get F2 to display ‘Arnold’ and F3to display ‘Brown’. Obviously these aresimplified versions of WSs with hundreds of rows.


Help? Thanks inadvance.

 

[Garry T]

Thank you. I'll try these. I tried copying/pasting values so both columns would be the 'same.' I also formatted both columns as numbers with no commas, etc., and again with both columns as text and again with both columns as general. I'll try the last option first, since I tried the other 2 from your previous advice to me. In any event, thank you for your time and advice!

 

[BravoBravoAu]

Try:

=VLOOKUP(B2+0,'Employee details'!A:B,2,0)

Hi Aladin - that formula seems to work for my WS. Thanks for your persistance.

 

[Aladin Akyurek]

Hi Aladin - that formula seems to work for my WS. Thanks for your persistance.

You are welcome.