populate columns A & B based on lookup in column C

This is a simpler example to one I had posted yesterday ... to which I didn't yet receive a response. Does this need to be merged with that other thread?

Please see the attached. I need to perform a lookup in column C, so that values in columns A and B can be populated (based on the result of the lookup). I'm thinking it needs to be a vlookup, but I've been unable to get it to work.

Suggestions appreciated ...

Thanks all.

Cutter - the data is not manually input. All the records are in the same list, but I thought a simplistic example would be best.

Richard Buttrey - you're right ... the actual data is more extensive (there are more than 4000 records), so I think my simplistic example may not be the best. In the attached updated spreadsheet, when I copied your suggested formulas, the data did populate correctly. However, since the actual dataset has thousands of entries, I wouldn't be able to perform that number of formulas manually.

If the data were to be in separate sheets, what would you suggest?

Originally Posted by Richard Buttrey

Hi,

This seems an odd layout with a mixture of data and results in the same columns. Can't this layout be simplified and the two sets of data separated. For this trivial data set the answers are as follows, but I can't help thinking your actual data is more complex than this.

A1: =INDEX(A:A,MATCH($C1,$C:$C),1)

B1: Copy A1 to B1

A4: =INDEX(A:A,MATCH($C4,$C:$C,FALSE),1)

B4: Copy A4 to B4

Rgds

I have looked at your file but can't understand what you're trying to do.

Where are the values in Col C coming from? Manual input?

You would need a table somewhere that lists all of the states/provinces/territories with the corresponding A and B data in order to accomplish a VLOOKUP() to fill A and B on the sample sheet.