Conditional Lookup Function 0
-
simple formula (0) 0%
-
Without VBA (0) 0%
Dear Excel forum,
Need help for following:-
Data for once source
Column A shipping container numbers (alpha & numerical)
Column B the container size code
Column C relevant date of arrival
Data from another source
Column D shipping container numbers (alpha & numerical)
Column E the container size code
Column F relevant date of shipment
What I want is:
If Column A containers match with Column B containers
Then in Column G the containers that matched and Column H the container size code
Column I the date of arrival
Column J the date of shipment
Vlookup seem to be an answer, but can’t get it to work.
I am not good in VB, so may be formulas would be better
Named range and IF & Match FORMULA may be?!!
The list will be approximately 20,000 numbers long.
Have attached the sample file.
Kindly assist.
Thanks & B.Rgds
Krishnan