I have a workbook containing 2 worksheets.
The first sheet is setup in rows, and contains a unique code in column A,
then lots of other data in several columns.
The second sheet is a 'Summary' page. The idea is that I want to enter a
code ( as found on the first sheet ), some kind of LOOKUP is performed to
match the code with the first sheet, then have other cells on the summary
sheet populated by the relevant columns as specified from the first sheet.
For example :
Data sheet contains five colums: A: Code, B:Name, C:Address, D:Phone, E:Email
Each row then contains the data 002 FRED 12 High St 020 345
fred@high
My second sheet has a cell where I enter my Code
It also has 2 cells for NAME and PHONE that I want to populate from the
first worksheet.
I tried VLOOKUP, but this doesn't work - as some rows in column a are empty
and I cannot sort the data either.
Any ideas?
Thanks.