fill in cell values from different sheet 1

[lespaul]

Hello all!

I have a workbook with two sheets: InterviewReport and Data. The Data sheet is filled in from a different program and ends up looking like this:

ItemName ItemValue
LastName Blow
FirstName Joe
Address 123 Main st
etc.

The information in DATA is never the same and is not in a very nice order. I have Named Cells in InterviewReport that correspond to the ItemName. I would like to have the named cells in InterviewReport filled with the VALUE of the DATA sheet where the ItemName matches the Named Cell.

Any suggestions?

Thanks!

Leslie

 

[DaleWatson123321]

Hi Leslie,

There is usually more than one option, and such is the case here... either using the VLOOKUP function, or a database function.

The following is an example of the VLOOKUP function, which is possibly all you require, depending on the specifics of the situation...

=VLOOKUP($A3,datalist,2,FALSE)

where this formula is entered in cell B3, and references the ItemValue entered into cell A3.

where "datalist" is a range name assigned to your data on the "Data" sheet. The offset "2" will reference the LastName.

You would simply copy the formula, and change the offset, to reference the other fields in your data.

Hope this helps. Please advise as to how you make out.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[lespaul]

Thanks for all the support Dale - the program is working MARVELOUSLY!! You deserve 10 GOLD STARS!

Leslie