I have two spreadsheets. Each have two columns of information that match. One of the spreadsheets has some information that I want to bring over. How can I do that?
For example:
SPREADSHEET 1
A B
123 AC
123 AD
578 AQ
578 AS
578 AT
123 AE
SPREADSHEET 2
A B C
123 AD 255
578 AQ 658
I want a vlookup in spreadsheet 1 that will look up the "123" "AD" in spreadsheet 2 and bring back the "255".
HELP
For example:
SPREADSHEET 1
A B
123 AC
123 AD
578 AQ
578 AS
578 AT
123 AE
SPREADSHEET 2
A B C
123 AD 255
578 AQ 658
I want a vlookup in spreadsheet 1 that will look up the "123" "AD" in spreadsheet 2 and bring back the "255".
HELP