Insert a row from one excel tab to another (1 Viewer)

[ielamrani]

Hi,
I have struggled with this to make it work. I did not create the excel sheet it was given to me already done.

If this is not clear please let me know.


the excel sheet with 2 tabs.

one tab contains the following fields (name, dob, ID, dis, nurse, art)
The other tab has fields ( Name, dob, Id, dis, nurse, Ven)


they're same except one has column art and one has Ven

I want to take the field Ven from tab 2 and insert it in tab 1 next to Art using the ID as away to match the patient.

here is an example:

Tab1

Name Dob ID Dis Nurse Art
X xxx 1x NC F 7.28
X xxx 1x NC F 7.24
B bb 1b C m 5.2
c cc 1c N m 6.2
c cc 1c N m 9

Tab2

Name Dob ID Dis Nurse Ven
X xxx 1x NC F 7.30
X xxx 1x NC F 7.01
B bb 1b C m 8.11
c cc 1c N m 1.2

The final result will be:

Name Dob ID Dis Nurse Art Ven
X xxx 1x NC F 7.28 7.30
X xxx 1x NC F 7.24 7.31
B bb 1b C m 5.2 8.11
c cc 1c N m 6.2 1.2
c cc 1c N m 9

 

[Trevor G]

You should be able to use a VLOOKUP formula to do this for you.