How to return values from different sheets

**SMB** · 12-09-2009, 01:31 PM

I pull a report (Form2), and I want to import values into another sheet (Form1)

From Form2, I want to import the cell value in $D# based on the name in cell $C#, when the name in $C# matches the value in D2 on Form1. Ultimately, the value from $D# will return to cell G5 in Form1.

Any suggestions?

**DonkeyOte** · 12-09-2009, 02:11 PM

Welcome to the Board.

Generally speaking - it's always better to provide sample files as opposed to images - unless you want help with an image of course

Regards your question - check out VLOOKUP function in XL Help

=VLOOKUP($D$2,Form1!$C:$D,2,0)

see also INDEX/MATCH functions should you need to look from right to left (ie from C to B or A etc...)

**SMB** · 12-09-2009, 02:56 PM

Thanks for the warm welcome!

I had previously tried the VLOOKUP, and was unsure how it worked. Once I reviewed what you had written, I think I had a better idea on what needed to be selected.

I changed a bit around, and now it works perfectly. Thanks for the help!