Cross Reference Cells

[HiDbLevel]

I am involved with regional sales and have developed a spreadsheet to track various statistics and information regarding the various cities and clients.

On Sheet1 I have Column A for the city names. Columns B through R are various statistical information (all numerical) associated with that city.

I would like to use Sheet2 to quickly draw that information into a generic "printable" spreadsheet such that I type a city name into Sheet2 A1 and the rest of the cells automatically draw the information for that city into their respective cells.

Looking through other threads I thought that maybe VLOOKUP would be the ticket, but it's only returning a #VALUE! error.

Any thoughts or ideas? Thanks!

[VBA Noob]

Can you post a sample workbook or at least the formula.

See link for tips on vlookup

http://www.contextures.com/xlFunctions02.html

VBA Noob

[arthurbr]

Hi and welcome to the board,
the error you got might have a number of reasons.
Could you post a small sample of your data ( as an XLS file ) and the error you got?

Cheers

[HiDbLevel]

Thanks for the quick replies!

I have attached a "watered down" version of the file. I notied that as I went through and edited the file, that now LOOKUP is returning #N/A and VLOOKUP is returning #REF!.

Also, for what it's worth, I'm running Excel '97. I doubt that makes a difference here, but I thought it was worth mentioning anyway.

[arthurbr]

Sorry, no file attached.
Check the Manage Attachment button on the Reply to thread form

[HiDbLevel]

Sorry about that....being new to the group here I'm a bit slow....lets try this again.

[arthurbr]

Does this help ( see attachment)

[HiDbLevel]

It's heading down the right road, but once I plugged the function into my worksheet it's not working consistantly. I have attached a modified version of the original file that I posted. You will see that I entered data in such that when you want to cross referance City 1 with Data 4, the cell will read, "City1-4".

[HiDbLevel]

I just figured it out. I'm not exactly sure what it does or what it means, but I had to have the Match Type set to 0.

It's such a good feeling when you get Excel to make life easier.

Thanks all!

[arthurbr]

Glad to hear you could make it work

Cheers